asked on

Export to CSV with SSIS

Hi,

This is what i am trying to achieve..

Create a CSV file delimited with pipes (|) without header definition, name the file according to a business rule and save it in a remote location..

I have heard a little about SSIS .. but nothing hands on..

Can someone tell me if this could be done with SSIS and if so and sample code / url will be helpful..

Thanks

Theepan

Bob Learned

Yes, SSIS can support CSV.

Part I Steps:

1) Create an SQL Server Integration project from the Business Intelligence Projects tree item in the File | New | Project dialog.

2) A default package will be created

3) Open the package

4) Add a control flow task (Data Flow Task) from the tool box.

5) Double-click on the data flow task, to edit the data flow.

6) Drop an 'OLE DB Source' onto the data flow designer from the tool box (Data Flow Sources tab).

7) Drop a 'Flat File Destination' onto the data flow designer from the tool box (Data Flow Destinations tab).

Part II to be continued.

justin_smith

ASKER

interesting....looks good..looking forward for part II ;-)

ASKER CERTIFIED SOLUTION

Bob Learned

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

justin_smith

ASKER

I would be glad if you woudnt mind ;-)
i will anyway try if i could take it from here

justin_smith

ASKER

Hi,
i managed to create a CSV and save in a remote location ..
I actually will need to create csv files with a specifc name pattern.. i will do a bit of searching on this

but how do i deploy this package on sql server or schedule it to run every day at a specific time

Bob Learned

What do you mean by "a specific name pattern"?

justin_smith

ASKER

Logs_dd_MM_yyyy.csv like format... was able to do it with variables though...

only confused about getting this deployed...

on the net ppl are talking about various options to deploy and run these packages

justin_smith

ASKER

could you please let me know how i could deploy the package and schedule it to run as part of the SQL jobs

Bob Learned

OK, I believe that we are getting off topic for the question, so you should close this one, and ask a related question (link at the bottom of the question).

justin_smith

ASKER

thanks for such a great answer.. a relate question follows ;-)