Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vishalj
Starting Member
32 Posts |
 Posted - 2006-05-16 : 13:05:22
|
| I have a DTS package which does the following1. EXECUTE SQL TASK (query in it) on success 2. Microsoft OLE DB (database connection) transform data task 3. Text File Destination (creates a text file TEST in a folder) on success 4. FTP ( I WANT TO FTP THIS FILE TO A SITE)The problem is I click on the FILE TRANSFER PROTOCOL TASK and its asks me to enter the FTP SITE USERNAME AND PASSWORDand then the destination DIRECTORY PATH.I don't know the path. What do I need to mention hereAlso when I click on file and select a Blank Text file from thereand check overwrite still after the task is complete data does not appears in that. ALTHOUGH IT SAYS TASK SUCCESSFUL even if I leave the destination Directory path BLANK.Does anyone knows how to figure this out. I am sure its a simple solution. |
|
|
|
|
|
FTP FILE USING DTS PACKAGE