what happened to DTS in SQL 2005? -
03-13-2006
, 02:41 PM
I'm new to VS2005 and SQL2005. I need to transfer data from SQL to a text
file programatically. In VS6 it was a matter of saving DTS from SQL2000 in VB
and implementing the code in a .dll file. Then the .dll was executed from ASP
file after passing needed parameters to it. It was pretty straight forward
and always worked.
Now in SQL2005 I can run DTSwizard that generates a XML file and... here I
get stuck. Where is my newfile.dtsx suppose to go and how can I run it from
the ASP.NET.
I'm totally lost!
Is there perhaps another way of doing this?
Can anybody point me in the right direction please?
I'm having hard time finding any info on this subject. |