I have a sql server connection, a text file (destination connection), and
wish the dump the contents of a table to a delimimted text file. I am not
new to DTS but have never attemtped this particular function before. I have
read about the dummy file table etc, but am still not getting this. Can
anyone point to a reference about who to accomplish this or have done this
and can email me ?

Where does the Write File transformation come in? This is when you might
have an image or word doc in a SQL Server table and want to write it out.

Write File Transformation
(http://www.sqldts.com/Default.aspx?294)

Do you mean simply an export to text file?

http://www.sqldts.com/default.aspx?278

--

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


"Jeff Block" <jblock (AT) REMOVETHECAPSANDINVALIDfirstlook (DOT) biz.invalid> wrote in
message news:ulONZmuoDHA.2776 (AT) tk2msftngp13 (DOT) phx.gbl...

I checked out SQLDTS , specifically about the dummy tables but am still
missing something here. Simply, I want to output the contents of a table to
a delimited file, effectively a bcp out. I can get it to 'work' but doesn't
output any data since the 'dummy' table is of course empty .. like I said,
I'm missing something here.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Then the second article should help although that is importing a text file.
What does the table structure look like ?

--

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


"Jeff Block" <jblock (AT) REMOVETHECAPSANDINVALIDfirstlook (DOT) biz.invalid> wrote in
message news:eaCE8QvoDHA.488 (AT) tk2msftngp13 (DOT) phx.gbl...

the source table is 65 varchar (25) columns is that is what you are asking
the dummy tables are set up exactly per the sqldts article
one time I got it to actually write to the file, it wrote only the first
column of the source table
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

If all you are doing is exporting a 65 * varchar(25) attribute table then
you shouldn't have any problems.

You only want to pump this out to text file right ?

Can I see the text file. Zip it and send it privately if you wish

--

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


"Jeff Block" <jblock (AT) REMOVETHECAPSANDINVALIDfirstlook (DOT) biz.invalid> wrote in
message news:%23R19HcvoDHA.2304 (AT) TK2MSFTNGP11 (DOT) phx.gbl...