I see that there is a component to import a file via FTP. Is there a process
that a DTS package can FTP TO a site? Thanks in advance

Hi,

Thanks for your post.

From your descriptions, I understood you would like to know how to upload
files to the FTP site. If I have misunderstood your concern, please feel
free to point it out.

Based on my knowledge, FTP task in DTS only support FTP gets but not
support FTP puts. Alternatively, you could use an execute SQL Task and
xp_comshell to execute the command line ftp utility to do this manually.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.