Need help in SSIS

• shiva1727

  SSC Enthusiast

  Points: 199

  More actions

  February 4, 2010 at 2:51 pm

  #141086

  Hi

  SELECT CONVERT(DATETIME,(STR(DATEPART(MONTH, CONVERT(VARCHAR(10),CONVERT(DATETIME,(STR(DATEPART(MONTH,CONVERT(VARCHAR(10),GETDATE(),101)))

  +'/1/'+STR(DATEPART(YY,CONVERT(VARCHAR(10),GETDATE(),101)))),121)-370,101)))+'/1/'+STR(DATEPART(YEAR, CONVERT(VARCHAR(10),CONVERT(DATETIME,(STR(DATEPART(MONTH,CONVERT(VARCHAR(10),GETDATE(),101)))

  +'/1/'+STR(DATEPART(YY,CONVERT(VARCHAR(10),GETDATE(),101)))),121)-370,101)))),111)

  Basically I have query in an Oracle I converted that into SQL Server

  for this I want which transformation is suites in SSIS

  I didn,t see any function Convert while using the transformation I used derived and condition split but in that

  we dont have Convert Function

  Plz help me to solve this prob

  Thanks!

  Shiva

• Tim Mitchell

  SSCoach

  Points: 15671

  More actions

  February 6, 2010 at 11:04 pm

  #1115152

  What are the data types you are trying to convert from/to? The SSIS derived column transformation allows you to convert data types quite well.

  Tim Mitchell, Microsoft Data Platform MVP
  Data Warehouse and ETL Consultant
  TimMitchell.net | @Tim_Mitchell | Tyleris.com
  ETL Best Practices

• wschampheleer

  SSCertifiable

  Points: 5504

  More actions

  February 8, 2010 at 12:47 am

  #1115312

  Look under Type Casts in the Derived Column Transformation.

  Regards,

  Willem
  http://wschampheleer.wordpress.com[/url]