Convert SSIS datetime to sql server 2005 datetime ?

• blasto_max

  SSCertifiable

  Points: 5025

  More actions

  October 28, 2013 at 11:47 am

  #278522

  I want to convert SSIS datetime obtained by getdate function into a database datetime variable. How do I do it ?

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  October 29, 2013 at 2:56 am

  #1662243

  Can you explain a bit more what you are trying to do?

  Where did you issue the getdate function?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  October 29, 2013 at 3:03 am

  #1662246

  Do you know what is SSIS variables and are you comfortable with Execute SQL Task in SSIS?

  Raunak J