I am trying to insert the
system:starttime variable into a table by passing a parameter into an execute sql task.
I dont have much knowledge of SSIS data types, and I am currently having trouble making this functionality work. When I set the parameters datatype to
nvarchar, the date is always inserted as 1/1/1900. When I use the
DBDATE type, the insert fails with the following error
unsupported data type on parameter binding 0
So my question is how do I pass a SSIS date variable into an execute sql task so that SQL Server can interpret it correctly?