DTS Wizard Errors

• n-igma

  Old Hand

  Points: 338

  More actions

  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.

• n-igma

  Old Hand

  Points: 338

  More actions

  March 15, 2002 at 8:49 am

  #425450

  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.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738093

  More actions

  March 15, 2002 at 10:12 am

  #425458

  add an alias to the columns iwth the function.

  upper(mycol) 'testname'

  Steve Jones

  steve@dkranch.net