March 15, 2002 at 8:29 am
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.
March 15, 2002 at 8:49 am
All resolved, well sort of. The upper function is not liked by the DTS wizard, any columns with upper applied are not recognised. Is this a bug??
Phil.
March 15, 2002 at 10:12 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply