sql server dts: DTS Newbie- exporting -- sql server dts

DTS Newbie- exporting

brian
12/23/2003 12:44:05 PM

sql server dts:

My company just got bought and I need to start exporting
data daily from our SQL 2000 server to a comma delimitted
text file. Is the following scenerio possible:

*Export header infomration for one order (such as order,
date, ship to)

*then add a carriage return to leave a blank space.

*Export the detail information pertaining to the report
(such as order line information)

*then add two carriage returns leaving 2 blank spaces.

I know nothing about custom exports. All I have ever
done are exports through the wizard. Can DTS handle
this? Is this a stupid way of doing this. The company
only wants 1 file.

When reading the exported data into there system will it
work? I think we should have 2 text files but that's not
what the boss wants. Please advise!

Re: DTS Newbie- exporting

Allan Mitchell
12/24/2003 5:58:02 AM

You are going to have to do custom handling of the export and import as the
file will be an invalid format for the text file provider.

You can export to multiple files and use COPY to merge them. When you want
to read them back in you can import into working tables and then join them
back up that way.

--
--

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

[quoted text, click to view]