...anyone have a solution to this.

Have 100 excel files stored in a table in binary format and need to export
them...have an asp application where I can pick them one but would of course
prefer not having to do that....

In message <#wlBcCbzEHA.1448 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Michael Vardinghus
<michaelvardinghus (AT) hotmail (DOT) com> writes
I'm not clear what you actually want to do, but if you want to extract
them to individual Excel files try the Write File Transformation.

An article on usage -

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

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

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

Think it's preciously this i need - just can't get it to work

Have a a filename column "filename.xls" and a binary column and tried to use
these to as source columns to a dummy table but it keeps on saying:

Error: Must have one source column of string datatype (containing filename),
and a different source column of string or binary datatype (containing)
file data....

And that's preciously what I've got so I don't get it....

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Then I got it !!!

Thanks Darren...


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote