I have a DTS package that is called from a SP in SQL Server 2000. When it is run from within SQL, the profiler shows that the Application "DTS Designer" is only called once and does it's tasks and returns the recordset.....
When the SP is called from via ASP, the profiler shows that...
I have a global variable (ImportFilename) that acts as the Datasource (ASCII filename) that is used in a dynamic properties task. It works fine when executed from within the pkg or even externally when the default property setting is used. I have tried many iterations to get the syntax correct...
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.