Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 pass ssis variable to stored proc

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2012-01-19 : 12:19:57
Hi,
I have a variable called IndexDate inside the ssis package.
The datatype is set to datetime.
In a sql task, as a parameter variable, i pass this variable in th eparameter mapping screen.
Question, what should the datatype be in this screen where you define the passed in parameters. I can see DBDate, DBTime, etc.

Thanks
   

- Advertisement -