Hi,
I need to export multiple tables to csv files. These tables are extracts of data created using SQL Queries for the purpose ofexporting to csv files and sent to an external service center.
I'm assuming I'll need to use an SSIS package to accomplish this. I've exported them manually using SSIS and all works well. I have not worked with SSIS logic beyond creating a package to export or import tables and saving the package repeated use. Can I create an SSIS package to export all tables that begin with four digits and an _, i.e. 1234_testtable, to a csv of the same name with a .txt suffix.
If so, what would the code look like and where would I put it.
Thanks.
Start Free Trial
