question

Teresa avatar image
Teresa asked

SQL 2008 FTP Task not sending file

I have a package that extracts data and sends those files to a remote server with the FTP task. The FTP task isn't working. When I created the ftp task manager and test the connection, it connects successfully. when I run the ftp task it fails and I get this message:

SSIS package "GasMeterLease.dtsx" starting. Error: 0xC002918B at FTP Task, FTP Task: Unable to send files using "FTP Connection Manager". Warning: 0x80020918 at FTP Task, FTP Task: Operation "" failed. SSIS package "GasMeterLease.dtsx" finished: Success.

I've been struggling with this for days.

Doesn anyone know what the problem is and how I can fix it?

sql-server-2008
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
TG avatar image
TG answered

I suspect that when you test the connection it is running under the security context of your login but when the SSIS package runs it is running under a different security contetxt which doesn't have permissions to either read the source files or write to the destination folder.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

mrdenny avatar image
mrdenny answered

Does the SQL Server which is running the package have access to FTP out to the Internet? Most companies restrict the access from the servers to the Internet.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.