I am trying to write a DTS package to export all the tables in a database to CSV files and I hope to do this with the DTS paclage picking up all the table names from the information_schema view

I know how to extract all table names into a recordset and store in a global variable
I know how to iterate the recordset and call a task parameterised with the table names

Please would someone help me with the Data Pump task to export the table to a CSV

Thank you.. Jack

Can you use this in a loop then ?

Bulk Export Task
(http://www.sqldts.com/Default.aspx?237)

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jack" <anonymous (AT) discussions (DOT) microsoft.com> wrote

table names from the information_schema view.

In article <DF56BE9A-088D-495E-93D1-A6B15791FA74 (AT) microsoft (DOT) com>, Jack
<anonymous (AT) discussions (DOT) microsoft.com> writes

The problem with the DataPump task is that you must set the source and
destination column collections and then add transforms between them all.
Whilst you could write some ActiveX Script to handle this, it is rather
hard work.

Personally I use a custom task I wrote, and then wrap this in a loop via
script. I can send you a demo package if you want.

Bulk Export Task
(http://www.sqldts.com/default.aspx?237)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org