Load data using SSIS

Question

Load data using SSIS

newbieuser

SSCrazy Eights

Points: 9423
More actions
August 25, 2016 at 11:11 am

#329681

Hi friends,
We need to develop a SSIS package to load data from ftp site onto SQL Server tables. After some research I found that I cannot import data directly from ftp and I will have to get the file to the SQL DB server first and do the import to the tables. I tried to create a SSIS package for this as below:
1. Created FTP task to receive files, put the file locally on the db server. Set DelayValidation-TRUE
2. Created data flow task:
Flat file source. (prompted for the source file, I read somewhere to create a dummy file just for the design work and later removed the flat file before execution).
Data conversion
OLE DB destination to the SQL Server table.
When I run the package, I get the below error:
Error: 0xC001602A at test, Connection manager "FTP Connection Manager": An error occurred in the requested FTP operation. Detailed error description: The password was not allowed
There is no password saved in the connection manager for the FTP task... Not sure what I'm missing... Can you please help me fix this problem. Thank you all so much

Viewing 7 posts - 1 through 6 (of 6 total)

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

newbieuser SSCrazy Eights Points: 9423 More actions · Answer 1

I googled about this error and found a solution to provide the serverpassword for FTP using a package config file. I did that and now I get a different error ...

Error: 0xC002F304 at FTP Task, FTP Task: An error occurred with the following error message: "Object reference not set to an instance of an object.".

Task failed: FTP Task

Please help.. Thanks a lot

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 2

First thing I would try is to delete the FTP task and then try to recreate it.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

tindog SSCarpal Tunnel Points: 4892 More actions · Answer 3

Are you able to share the properties of your task please?

Smendle Hall of Fame Points: 3969 More actions · Answer 4

I would try 2 things at this point.

1. Try using a password like 12345 (I know same as your luggage, haha never heard that one before) some FTP sites will accept ANY password for a no password account.

2. If you have control over the server or can contact someone who is, have them place a password on the account you are using.

newbieuser SSCrazy Eights Points: 9423 More actions · Answer 5

Sorry about the late response..

The problem was the folder path I mentioned for FTP had multiple files and sub folders in it. I removed all the other files and sub folders and re-created ftp task with only one file and it worked.

THanks a lot for all your help

MMartin1 One Orange Chip Points: 27764 More actions · Answer 6

provide the serverpassword for FTP using a package config file.

I know this is the quickest and easiest way to go about it. You know that you are storing a password in clear text in a file somwhere that others may have access to. There is a feature to save sensitive information like passwords in registry entries through the configuration manger, and that would be better. OR you can ecrypt the package with a password that is entered into a GUI when you call the package.

----------------------------------------------------