Variable used for insert Data Transofrmation & EXEC SQL Task (SP)

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  March 31, 2012 at 4:17 pm

  #266477

  I need to assign the current DateTime to a variable and use that value in a Data Transformation Task in an SSIS PAckage.

  On some of the Task I have to use a Stored Procedure to load the Table because I'm getting erroneous truncation errors from the source AS400 Data.

  For the transformation tasks do I need a derived column task?

  I seem to recall that a variable can be passed an an input parameter to the Execute SQL Task?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  April 1, 2012 at 11:41 pm

  #1467486

  How to: Map Query Parameters to Variables in an Execute SQL Task

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