Hello,

Does anyone has the example for uploading the file to a different
server from the server where the DTS process runs using FTPTask.

I have done downloading the file to the server where DTS runs. I need
the example for uploading.

Thanks.

Look into the custom DTS Task from www.sqldts.com to upload files. Easier to
use if the file names are always the same, but still doable.

-Pete

"Yunus's Group" <yunusasmath (AT) gmail (DOT) com> wrote:

Thanks for your reply.

I did look check the article on "Custom DTS Task". When I tried running
the package. I got an error.

Task "DTSTask_SQLDTSFTPTask.xxxxCustomTask1" not found.

Also, when I tried some of the properties that are mentioned in the
article, for example: "Direction" property, I got an error.

Property "Direction" not found.

Have you done anything of this sort?

Thanks in advance.

You need to install the SQLDTS FTP Task.
Any code sample that references a task by name, will need verifying to
ensure your task name matches.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Yunus's Group" <yunusasmath (AT) gmail (DOT) com> wrote

Along those lines, you'll need to install it on any machine that may need to
design that package as well as those that will run it. Had problems in the
past when we added this custom task to a couple of jobs and people couldn't
open them anymore.

-Pete

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote:

Thanks Pete. That was helpful.