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.
| Author |
Topic |
|
vk59
Starting Member
38 Posts |
 Posted - 2005-06-09 : 10:01:14
|
| Hi,I am Exporting Data from Fox Pro 2.6 to SQL Server Using DTS VBScript. I have two dbf files from two different customers which has same structure except one column. File1 has 3 columns namely COL1, COl2 & COL2. File2 has only two columns COL1 & COL2. While Executing the package i get the following error.Step 'DTSStep_Step1' failedStep Error Source: Microsoft Data Transformation Services (DTS) Data PumpStep Error Description:Column name 'COL2' was not found.Step Error code: 80042008Step Error Help File:sqldts80.hlpStep Error Help Context ID:0Should I have two seperate DTS packages to export them.Thanks In AdvanceVK59` |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Column Missing