Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ASP called SQL Server DTS package runs it 2x
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...- dkern
- Thread
- Replies: 0
- Forum: Microsoft: ASP (Active Server Pages)
-
Setting Global Var inside pkg from SProc
Many Thanks.... the final syntax was modified just a little to put the entire 2nd parm in single quotes to force as a string.... EXEC @hr = sp_OASetProperty @oPKG, 'GlobalVariables("ImportFilename").Value', @Filename Thanks again for your efforts!- dkern
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Setting Global Var inside pkg from SProc
Thanks for the tip.....I have tried it but it does not seem to be setting the value properly. In fact when I use the sp_OAGetProperty (pre and post my sp_oasetproperty) on the property it returns null. The pkg runs successfully using the defaulted value of the variable in the pkg. Perhaps it is...- dkern
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Setting Global Var inside pkg from SProc
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...- dkern
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
