Hi,

You can try like this, In Execute Sql task Editor -> SqlStatement give statement as below

INSERT INTO [dbo].[BigCounter]

(CounterID)

...

Hi,

You can use it as shown below:

SELECT [master].[dbo].fn_sqlvarbasetostr(@@DBTS)

There is a predefined scalar function in Master database to do this.. 🙂

Regards,

Navamohan K