SSIS FTP Task

  • Im creating an FTP Task and have created an FTP Connection manager and associated it with the task (Test connection is true, so the actual connection to the ftp server works)

    When I try to run the task I get an error

    For the ftp operation "Receive", the file connection manager "" can not be found

    Ive tried deleting and recreating the FTP connection manager, but nothing seems to work, no matter what I try, the FTP task refuses to believe that a valid, working FTP connection manager exists.

  • Is this the same?

    http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/46d1df1a-ae95-432d-b6b3-baa88efdbfee/

    Also in the 2005 forum there's this which seems to relate: http://www.sqlservercentral.com/Forums/Topic478084-148-1.aspx

    .. local paths heh? Whatever next! :hehe:

  • the answer was obvious now, I hadnt set the local destination for the downloaded file

  • It always is the simpliest of things that causes the most frustration.

    Good luck with the rest of it.

  • I have another question related to the FTP download. The name of the actual file will change from month to month, but the naming format will always be the same

    eg 01012009.db 01022009.db 01032009.db, etc

    how can I tell the ftp task to download the file for each particular month ?

    I will be running this as a job once per month, so it will always be run in the month relating to the file name

    so in january 2009 i download 01012009.db in feb its 01022009.db, etc

    Im assuming I can create a variable filename based on the date ? Any pointers ?

  • However you've set it up to look for that file, use an expression to overide.

    How you do the expression is up to you. You may be running it month by month, in which case you could just use a reformatting of the current date, or like you say pass in a variable. I'd personally base if off a variable formatting.

  • im still having problems with the FTP task. Ive setup a variable named 'SourceFTPFile'

    Its scope is the entire package and its a string. In the value column I have

    'Data 010109.zip'

    In the FTP task editor window I have

    IsLocalPathVariable False

    LocalPath 'DestinationDirectory'

    OverwriteFileAtDest True

    Operation Receive files

    IsTransferAscii True

    IsremotePathVariable True

    RemoteVariable User::SourceFTPFile

    I get no errors indicated, but when I run the package i get this error

    Error at FTP Task. Failed to lock variable "/Data 010109.zip" for read access with error 0xC0010001 The variable cannot be found

    When I go back into the FTP task editor, the RemoteVariable has been changed form its original value of 'User::SourceFTPFile' to '/Data 010109.zip'

    so somehow, the name has been changed to the value ! thats why it cant be found.

    Nothing I do will stop this from happening

    Can anyone help ?

  • Hmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm.. ok honesty first: I've not done what you're doing, so am guessing. Whether it will help or hinder, I don't know. Hope it does help though:

    Could be a bug in SSIS...

    http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126207

    http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/2b7cf6b5-d16d-44cd-954d-68e9ba98ee91/

    http://www.bigresource.com/Tracker/Track-ms_sql-C87dPy2B/

    But that was reported 3 years ago and for 2005.. so may be unlikely, but a possibility? Seems an issue if you're connecting up to Unix ftp sites.

    Also found these walkthroughs just to help you double check things:

    http://www.sql-server-performance.com/articles/biz/data_profiler_ftp_task_ssis_p2.aspx

    http://www.techbubbles.com/sql-server/using-file-system-task-and-ftp-task-in-sql-server-ssis/

    As I say, I am guessing. Hopefully you'll crack it - and if you do write an article on it for others! 😉

  • Is there supposed to be a space in the file name, '/Data 010109.zip'?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply