Hi All,

I hope someone can help me,
I created a DTS job using the wizard which reads a tab delimitied text
file and inserts it into a table, and saved it to a bas file because i
need to use it in VB and dynamically change the filename.
However when I run (having referenced the three dlls, dtsdatapump, dts
package and dtscustom...)the program I get an error
Step Failed Microsoft Data Transformation Services (dts)Data Pump
Column Name 'Col002' not found.

Can anyone provide me with any indight into this?
I havent changed any of the code generated from the package by the DTS
wizard -
Any help would be appreciated,

Thanks,
Berní
--
Direct access to this group with http://web2news.com
http://web2news.com/?microsoft.public.sqlserver.dts
To contact in private, remove n-1o+sp1p8amm

Have a look at the file you are trying to import. As the error suggests it
is looking for a column header of col002 and hasn't found it.

--


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

"bernif" <bernif.news.invalid (AT) web2news (DOT) net> wrote