General discussion


Execute a DTS package from a SQL Server stored procedure

By kiran harile ·
Hello everyone, I have got stuck in a big mess. The situation demands creation of a DTS package based on a query in SQL server and then execute it to produce the output in a text file. My problem is that I am completely new to this DTS stuff, so can anyone please help..??

Here is the exact thing I want to do :-

1. Create a DTS package based on a query.

2. Execute the package using .NET.

3. On the completion of the DTS package execution, send a mail stating the success or failure of the DTS package execution. The mail should be .NET generated.

Below are the things which I have tried to do on my own and my queries regarding the same :-

1. I have generated a package for a particular query, using SQL enterprise manager but dont know how to pass parameters to the package when executing it.

2. Is there any way to make the above package creation dynamic? I mean can we create a DTS package using .NET?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Google the following

by Tony Hopkinson In reply to Execute a DTS package fro ...

run dts package from .net

first three or four links should get you somewhere.

Better off passing the parameters for teh query , or even the query text itself to teh DTS package to run it.

Google is your best mate...

Related Discussions

Related Forums