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?