DTS Wizard Errors

Question

Post reply

DTS Wizard Errors

n-igma

SSC Veteran

Points: 278

March 15, 2002 at 8:29 am

#158161

Hi,

I have written a query to pull out data and format it to a client's requirements, however when I try and export this data to a .csv in the dts wizard I get an error about transformations required. The transformations dialog only shows three columns!! (id, title & dob) Can anyone tell me why this is occuring and how I resolve it?



SELECT DISTINCT 

    u.id, u.title, UPPER(u.firstname), UPPER(u.lastname), 

    UPPER(u.email), UPPER(u.email_format), 

    [dob] = CAST(day AS VARCHAR) 

    + '/' + CAST(month AS VARCHAR) 

    + '/' + CAST(year AS VARCHAR), UPPER(u.address), 

    UPPER(u.address2), UPPER(u.town), UPPER(u.county), 

    UPPER(u.postcode), UPPER(u.country)

FROM users u INNER JOIN

    surveys_completed s ON u.id = s.user_id

WHERE u.postcode IS NOT NULL AND u.country = 'GBR' AND 

    s.survey_id = 9

TIA

Phil.