Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Column Name Not Found

Author  Topic 

smallrinilady
Starting Member

4 Posts

Posted - 2007-03-13 : 14:19:50
I had previously created a table which I then dropped to recreate it with an added column called 'vmc'.

The file used to create the DTS has a column called 'vmc' with populated data. The table design has a column called 'vmc'. But when I execute the DTS it gives me this error saying "Column name 'vmc' as not found."



is there a caching issue maybe?

i used the same code to generate table2
created another DTS for table2 from the same original data file

and everything went through fine

how do i make this work for the original table

X002548
Not Just a Number

15586 Posts

Posted - 2007-03-14 : 11:18:24
You probably will have to recreate the DTS Package...but why not use bcp instead?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -