January 25, 2006 at 2:01 pm
Hi, this is my first time building a DTS package, and I don't have any good sources of information to learn DTS from. I am trying to build a package that would extract data from the database, create a CSV file with the results, then FTP it to an FTP server as well as email the file as an attachment to several email addresses. Is it possible to do it in that order, as in create a CSV file first? If so, how does it work?
Thanks in advance to everyone spending time on this thread.
January 25, 2006 at 2:23 pm
January 26, 2006 at 3:06 am
Very quickly, you need
1 x SQL Server connection, 1 x Text File (destination) connection, 1 x transform data task (between these 2 connections), 1 x File Transfer Protocol task (after the transform data task, click on the destination connection, ctrl click on the FTP task, select 'Workflow - On Success') and 1 x Send mail task (after the FTP task, 'On Success' as before).
If you are unsure of the settings in these you can always click on 'Help' or look at the resource lucky recommended.
(Marvin)
January 26, 2006 at 4:02 am
I think the FTP task only does get, it does not do put. Thereare 3rd party FTP tasks available that support both..
Alternatively yo can use an Activex script task and automate http://ftp.exe
Watch out for issues with passive mode on ftp - if you hit this problem please post here.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply