I have created a DTS Packaget that successfully transfers files from an FTP -
sometimes. If I execute each step manually, the FTP transfer succeeeds.
When I execute the package, sometimes the FTP package succeeds, and sometimes
it does not.

I checked all the parameters that I am dynamically setting for the FTP site,
and I believe they are correct (How else would my manual set through
succeed?).

I'm thinking that the dynamic property is setting the FTP task a little too
quick? Is it a problem with a binary within the file? The file should only
contain text, but this also does not explain why I can walk through it, and
not run through it?

Perplexed in Calgary....Thanks in advance for your time.

Richard

What is the error?


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

"codputer" <codputer (AT) discussions (DOT) microsoft.com> wrote

I simply got the DTS Package failed message, but (as I'm new to DTS) there as
got to be a better error message than that! So I looked into my event log,
and dug this out...

Step 'DTSStep_DTSFTPTask_1' failed

Step Error Source: File Transfer Protocol Task
Step Error Description:Failed to connect to the internet site for file
transfer.
Step Error code: 800403F1
Step Error Help File:
Step Error Help Context ID:0

When you execute a DTS package within the designer (not the step, but the
package), does it not use the same security rights as ther user that is
executing the request?

Why would the task succeed as a step, but fail during an execute?

Thanks in advance for your time,
Richard

"Darren Green" wrote:

After some more testing, I'm still at a loss why the FTP task will not login
properly. It appears that if the FTP site takes too long to respond, the
task simply gives up. I've increated the repeat try count, and it's still a
no go.

To stablize the whole scenario, I have to write out a script log, then shell
out to FTP, using the script log to login and download the file.

Talk about a hack! Let alone the security issues...Hasnt' someone built a
robust FTP task for DTS????

Perplexed in Calgary....



"codputer" wrote:

You could give the one on sqldts.com a try:
http://www.sqldts.com/default.aspx?302

-Sue

On Thu, 27 Jan 2005 11:33:02 -0800, "codputer"
<codputer (AT) discussions (DOT) microsoft.com> wrote:

In message <7990BBDD-1AD0-42A8-85DB-55649B073FE9 (AT) microsoft (DOT) com>,
codputer <codputer (AT) discussions (DOT) microsoft.com> writes
It's a hack but it generally works, and much more reliable as well, if
not as flexible. You would not believe how difficult it is to write a
reliable FTP. I tried, and it works fine for me, but the variations out
in the big wide world have caused me no end of grief.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thanks Darren for your reply...It does seem to work much more reliably. I
did try to use your control, but it too could not seem to connect. In
addition, I got to pull files from various directories...so in the end, I
went back to the script.

I know that DTS is rewritten in 2005 - is this piece any better? Have you
played with it?

I'm starting to write a significant application, and I'm been toying with
implementing it in 2005 - is beta 2 stable enough? close enough? too much to
learn?

Thank in advance for your time,
Richard

"Darren Green" wrote:

In message <0122612F-102F-47EF-A045-93E21FB0EB5B (AT) microsoft (DOT) com>,
codputer <codputer (AT) discussions (DOT) microsoft.com> writes
Well it supports both upload and download, and has a couple of extra
options compared to SQL 2000, but it is not everything to all people no
doubt. The overall architecture does make it quite easy to do dynamic
stuff with tasks, setting task properties and such like is more
flexible, and powerful. To be honest you may be better with something
like webdrive.

I haven't had any issues with it, but then I never had issues with the
existing tasks, mine or MS, when it came to reliability.

Cheers


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

When executing a DTS package manually the FTP and other execCMD functions will execute on the machine you are logged into. So if you are executing the DTS from Enterprise Manager on your desktop, the FTP connection will actually occur using your local routing and security on your desktop.

It sounds like this problem is that the SQL server machine does not have a viable route to connect to the FTP server, however your local machine where you execute from does.

I suggest checking your servers routing tables and firewalls to make sure it has the ability to reach the ftp server in question.

From http://www.developmentnow.com/g/103_...DTSFTPTask.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com