sql server dts: Column Name Not Found -- sql server dts

Column Name Not Found

bernif
7/7/2003 3:29:01 PM

sql server dts:

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

Re: Column Name Not Found

Allan Mitchell
7/7/2003 5:01:06 PM

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

[quoted text, click to view]