How to pass start and end dates as an input parameters in SSIS

• csajid

  Old Hand

  Points: 378

  More actions

  February 10, 2009 at 9:18 am

  #130840

  Dear All,

  We have recently migrated our SQL 2K production database to 2K5 environment. We are completely dependant upon DTS/SSIS packages.

  In one of our DTS package we were using start and end dates as a parameter input for SP.

  we have been facing the issue in passing/mapping the parameters to SP(s). these SP(s) which have to be executed under SYBASE environment require start and end dates as input parameters. These parameters have to be passed from SQL environment. But currently we are facing challenges in mapping the parameters (Start and END date) in SSIS.

  If someone gone through this situation then please share your inputs.

  Thanks in advance.

  Regards,

  Sajid C.

• vishal.gamji

  SSCertifiable

  Points: 6126

  More actions

  February 10, 2009 at 11:25 am

  #941494

  Use derived columns in dataflow task with GETDATE function.