I am using SQL Server 2005 - CTP June 2005 and I am trying to create a simple FTP task. Currently, my package consists of one FTP Task object in the Control Flow tab. I create a new FTP Connection Manager using <New Connection> in the FtpConnection property and verify the connection by selecting the "Test Connection" button. So far so good. However, when I return to the designer a red X appears in the FTP Task object with the following error:
"Error 1 Validation error. FTP Task FTP Task: Attempt to read message string for 0xc002f313 failed with error 0xc02090f3. Make sure all message related files are registered. Package.dtsx"
If I execute the task as is, I get the following runtime error:
"Error at Package: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error at FTP Task [FTP Task]: Attempt to read message string for 0xc002f313 failed with error 0xc02090f3. Make sure all message related files are registered.
Error at FTP Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)"
When I edit the FTP Task, the FtpConnection is set properly. What am I doing wrong? Any help would be greatly appreciated. Thank you.
Clay Benoit
Hi ClayThis is a validation error telling you to complete the properties in the FTP dialog, either select send or the receive option with complete valid paths
for example of FTP please try the http://www.sqlis.com/
Thanks|||I get the same error:
Error: 0xC002918A at FTP Copy blahblah, FTP Task: Unable to receive files using "FTP Connection Manager".
Error: 0x80004005 at FTP Copy blahblah, FTP Task: Attempt to read message string for 0x80020918 failed with error 0xc02090f3. Make sure all message related files are registered.
I have a FTP component with wildcards on the files
(RemotePath: "/somewhere/myfile*.*")
OverwriteFileatDest : False
Local path is "Existing Folder" with proper local folder unc.
The errors come after the list of files that could not be copied because they already exist on the local machine.
any ideas?
Horseshoe
It appears that your setup is corrupt because it cannot find the error messages file.
You're attempting to download files to a location where identically named files are stored yet you have OverwriteFileAtDest set to false. Move the files or set that property to true and the task should succeed.|||
This looks like a bug to me
The first error is valid - the file does not exist
Error: 0xC0029183 at FTP Delete XST from Remote, FTP Task: File represented by "User::XSTFile" does not exist.
Error: 0x80004005 at FTP Delete XST from Remote, FTP Task: Attempt to read message string for 0x80020918 failed with error 0xc02090f3. Make sure all message related files are registered.
The second looks like someone at MS fast fingered 29183 as 20918, and that message is not in the message files.
So you get two errors for the price of one...
Is there a way to make an expected error not increment the error count? Or do you just have to set the MaxErrors high enough to not have it matter?
|||Here is what worked for me...
It turns out of course that the ftp site was unix. I knew the variable as /subdir/file.txt.gz but I could not get that file to download, much less the others I wanted to itterate. I tested localy using FileZilla FTP Server on a local windows box and it worked perfectly. It was not until I decided to NOT use my generated file location variable and to use a design time fixed variable that it became clear that a Unix path was needed. What looked to me in IE as /subdir/file was was really /export/home/subdir/subdir/file. Only after I specificaly picked the file I wanted with the FTP Task did the real path show up.
Hope this helps.
