Monday, October 18, 2004

How we can run a DTS Package from ASP

Every programming language has its own beauty and wealth. But as a developer we know only things what we need at the time of coding. Like that here it is another thing. We can run a DTS package from Active Server Pages where it is very need to us, sometimes.
When one of my friend asked how to access a DTS Package from ASP, after he met some authentication problem. He also noted that the DTS Package well executed when tried in Query Analyzer. Both of us know there was a problem in some authentication, but don't know the solution. And again Google helps and we found at MS KB article. And it explore new things (may be, new for me). If You also want to know about, just read the article under the heading Execute a SQL Server DTS Package from Active Server Pages at the URLstep (like..doorstep) http://support.microsoft.com/default.aspx?kbid=252987.