February 20, 2006 at 11:49 am
I am currently building an ASP.Net web app and implementing SQL Server 2005 for a project. I was relying somewhat on kicking off SSIS packages from the web app, but I am not really sure how to do this.
If anyone could help me out, I would really appreciate it.
February 20, 2006 at 2:35 pm
What I use to launch a DTS from an application is a PROC
exec master.dbo.xp_cmdshell 'DTSRUN /S Server /U User /P Password /N IMPORT_Distributor_Sales_Fact', OUTPUT
Or you can use a job and execute a job
February 21, 2006 at 5:47 am
The classes exposed by Microsoft.SqlServer.Dts.Runtime should do the trick. There are samples in ASP & C# in the Wrox book (http://www.amazon.com/gp/product/0764584359/sr=8-1/qid=1140525802/ref=pd_bbs_1/002-4538442-1224846?%5Fencoding=UTF8)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply