This is the code from the DTS package where the Global Variable is update everytime a new record is entered.
**********************************************************
' Copy each source column to the destination column
Function Main()
Dim curDate, loggerID
loggerID = "E3226-01"
curDate =...
Problem:
I have a DTS package scheduled every morning to import data form a .csv into our SQL Server Database.
In the package I have multiple .csv sources processing data into one SQL Server destination.
Each .csv source has its respective Global Variable to record the date of the last...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.