December 3, 2009 at 8:02 am
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.
December 3, 2009 at 8:40 am
Is this the same?
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:
December 3, 2009 at 10:01 am
the answer was obvious now, I hadnt set the local destination for the downloaded file
December 4, 2009 at 4:23 am
It always is the simpliest of things that causes the most frustration.
Good luck with the rest of it.
December 4, 2009 at 4:48 am
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 ?
December 4, 2009 at 4:52 am
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.
December 7, 2009 at 3:41 am
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 ?
December 7, 2009 at 10:26 am
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://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! 😉
December 7, 2009 at 10:57 am
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