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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy