Hi,

I want to store the System::StartTime in my Integration Table Log. Please guide how can I use this in my Execute SQL Task Block. I write this SQL Statement:

INSERT INTO CMN_tblIntegration VALUES ('HRM_tblParty', ?) Which the ? is for the parameter. I go to parameter mapping tab and map the System::SatrTime to parameter0, but the package fails to run. I also changed the ? to @IntDate and also changed the parameter name but the error was the same.

Please help how to write this System Variable value in to that table.

Regards,
Sassan

I just ran this:
INSERT INTO dbo.TestDate VALUES(?)
Successfully.
Parameter mapping was:
Variable Name: System::StartTime
Direction: Input
Data Type: Date
Paramater Name: 0

I tried Data Type of DBTimeStamp, but it didn't work. I keep getting mapping errors. But with Date, it called the database like this:
exec sp_executesql N'INSERT INTO dbo.TestDate VALUES(@P1)', N'@P1 datetime', 'Mar 8 2006 10:34:22:000AM'