I need help writing an SSIS package that will create a .csv document and then FTP it

Hi Experts,
I need help writing an SSIS package in SQL Server 2008 R2.

The package needs to run a query, and then place the query results in a .CSV file.  
Once the .CSV file is created, it needs to be saved to a specific folder.
After the file is saved in the folder, it needs to be FTP'd.

How can I do this?

Thank you in advance,
mrotor
mainrotorAsked:
Who is Participating?
 
APoPhySptCommented:
Hi

I've worked with SSIS packages before, and I think that what you want to achieve is possible.
Let's devide the answer in hand into two groups.

1- Export the results of a query to a CSV:
https://dwbi1.wordpress.com/2011/06/05/ssis-export-query-result-to-a-file/

2- Copy the newly create .csv file to a FTP:
http://www.mssqltips.com/sqlservertip/2884/sql-server-integration-services-ssis-ftp-task-for-data-exchange/

Both links are well explained and have lots of pictures

Best Regards
APoPhySpt
0
 
Vikas GargBusiness Intelligence DeveloperCommented:
HI,

You can take a DFT in it Oledb source in which you can write the query to fetch data from source and take flat file as destination.

you file will be stored to the flat file connection manager path.

Then you can use the FTP task to transfer your file to the required destination.
0
 
mainrotorAuthor Commented:
APoPhySpt,
I will thanks for the information, I will try it.

Regards,
mrotor
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.