HighTechTalks DotNet Forums  

what happened to DTS in SQL 2005?

Dotnet Data Tools microsoft.public.dotnet.datatools


Discuss what happened to DTS in SQL 2005? in the Dotnet Data Tools forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Peter
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.