Apologies in advance for hitting the newsgroup with such
a 'clueless noob' question...

I'd like to import a series of external raw binary data
tables into a database. I've already defined the database
tables that I want this data to go into and assigned the
various columns the appropriate data types. How do I put
the data residing in the raw binary file into the database
tables?

It appears (to me anyway) that raw binary isn't supported
by DTS... though I find this hard to believe... and as far
as I can tell bcp is used for either native or ASCII
formatted data with the help of a format file.

My instincts are telling me I've overlooked something
obvious... but I have to admit that I'm stuck...

Thanks,
-fpsiv

In article <0f4801c3894c$f8acf470$a301280a (AT) phx (DOT) gbl>, fpsiv
<seelosiv (AT) aol (DOT) com> writes
Perhaps the Read File Transformation is what you want? This is an
article on the Write File Transformation, so just read it upside down
The two work in a very similar manner, so it should help. Also check out
the relevant topics in Books Online.

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