Sunday, February 26, 2012

DTS mapping global variable to column

Hi
I have doubt in DTS -i want 2 export text file into Database - which i can able to do it while running DTS it will prompt inputbox to enter the datetime of transferring which i should update in the datetime column of the table,which i will store this user input value in globalvariables- so how should i map to column.
i placed text object (source) and connection object and active x script object

thanks in advance
HrMay search SQL DTS (http://www.sqldts.com) website.

No comments:

Post a Comment