April 1, 2008 at 2:54 pm
I'm having a nincredibly diffcult time trying to get a very simple and basic package to work in SSIS. I can't believe how over complicated Micrsoft has made DTS -> SSSIS!
My end goal is to create a package that will ftp data every night from an already defined view in a specific database. I finally (after many hours) managed to get the package to work so that it will create a txt file locally of the data returned by this view. I'm now trying to change the package to FTP that same data and I'm hitting a brick wall.
The error I'm currently getting is as follows (Copied from BI Studio):
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Residence_Export: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error at FTP ADMFS [FTP Task]: Connection manager "" can not be found.
Error at FTP ADMFS: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
I've tried adding an FTP connection before the FTP Task and selecting the FTP connection from the drop down list in the FTP Task's Properties and I've tried creating a new FTP Connection from the FTP Task by clicking and nothing seems to work. The Test Connection on the FTP Connection is succesful everytime so I know I have the right credentials/login info.
If anyone has any idea of what I'm doing wrong I would be extremely greatful for any help you can provide.
I know that SSIS is powerful but it sure is a P.I.T.A. to use for non-complex ETL processing.
Thanks
Ed
Kindest Regards,
Just say No to Facebook!April 16, 2008 at 7:29 am
I am having this exact same problem... SQL 2005 sp2, WinXP. For testing purposes, I created a totally empty ssis package except for an FTP Connection Manager and an FTP task. When I created the connection manager, I tested the connection successfully. However, I also noticed that if I close the connection manager properties dialog box and open it back up again, it the "password" box is now blanked out and it fails to connect when I test again. I'm wondering if this is related? Was there any resolution to this issue? Am I just doing it wrong? Any help would be greatly appreciated. Thanks.
April 16, 2008 at 8:34 am
acrouch (4/16/2008)
I am having this exact same problem... SQL 2005 sp2, WinXP. For testing purposes, I created a totally empty ssis package except for an FTP Connection Manager and an FTP task. When I created the connection manager, I tested the connection successfully. However, I also noticed that if I close the connection manager properties dialog box and open it back up again, it the "password" box is now blanked out and it fails to connect when I test again. I'm wondering if this is related? Was there any resolution to this issue? Am I just doing it wrong? Any help would be greatly appreciated. Thanks.
Unfortunately I have yet to resolve this myself. My boss is telling me to open a support issue with Microsoft about this but I hate to do that when something like this should be addressable without haveing to pay Microsoft monies for support on it. It just seems like the documentation on SSIS 2005 is very porr, much more so then any other part of the SQL Server 2005 suite.
Should I open an issue with Micro$oft on this and resolve it, I will post the answer here.
Kindest Regards,
Just say No to Facebook!April 16, 2008 at 4:50 pm
acrouch (4/16/2008)
...if I close the connection manager properties dialog box and open it back up again, it the "password" box is now blanked out and it fails to connect when I test again.
This post will probably answer that question; Problem with FTP Task in SSIS on SQL2005
April 18, 2008 at 5:23 am
Well, fortuenately, I was able to identify the source of the problem, unfortunately, it appears to be my own mistake. It is, apparently, a requirement that all of the File Transfer dialog be filled out correctly. I was incorrectly assuming that that wasn't the case.
May 20, 2008 at 10:40 am
I am having the same issue, it seams the ftp dose not know about the connection manager, thats why it is showing "" anyone find a solution yet?
May 20, 2008 at 11:55 am
Found my issue, needed to set local file path.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply