I have DTS Package,which I need to migrate to SSIS.
In my DTS I have 3 ActiveX scripts: one creates file with different name every day(Date Extension like FileName_YYYYMMDD). Then data transformation transform data from stored proc to this file. Second one creates another file (title) with...
In DTS I used workflow ActiveX script to determine File Existence and depends on the result run one of the following tasks.
I had a global variable with FileName. Then in ActiveX script I had script like this:
Function Main()
Dim oFSO, sFileName
sFilename =...
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.