How to get flat files from FTP location onto SQL Server

Question

Post reply

How to get flat files from FTP location onto SQL Server

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

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

Adiga One Orange Chip Points: 27284 More actions · Answer 1

You may use xp_cmdshell to execute the command line parameters for the FTP command. Also you may try using SSIS

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

allen davidson SSCertifiable Points: 7042 More actions · Answer 2

Currently i am doing it manually by drag and drop method

Sounds like you already have a load method and you just need to get the files, I would use SSIS FTP task to pull each file in turn and drop into your load folder.If the source is secure FTP then the in box FTP component will not work but there are scripts available or use Cozy Roc SFTP component (it's good)

pinky SSCommitted Points: 1997 More actions · Answer 3

I havent used FTP Task till now. Can you please let me know how i can do this with the FTP Task?

allen davidson SSCertifiable Points: 7042 More actions · Answer 4

allen davidson

SSCertifiable

Points: 7042

July 30, 2010 at 11:50 am

#1200488

Have you used SSIS?

pinky SSCommitted Points: 1997 More actions · Answer 5

Yes but not much. I worked most on DTS. I didnt use FTP task till now in SSIS. If you can brief me how to use FTP TASK for my automated process that would be great.

allen davidson SSCertifiable Points: 7042 More actions · Answer 6

Try this article

http://msdn.microsoft.com/en-us/library/ms137656.aspx