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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-19 : 10:25:50
|
| dan writes "I'm trying to import a tab-delimited text file (with column headings in the first row) into SQL Server 2000 (SS). When I create a DTS package in SS and run it, it works fine. However, when I save the package to VB and use the code to import via a VB app, I get an error (via the Windows application event log):Step 'Import data to lkISOLAddressPPC' failedStep Error Source: Microsoft Data Transformation Services (DTS) Data PumpStep Error Description:Column name 'O/E/B' was not found.Step Error code: 80042008Step Error Help File:sqldts80.hlpStep Error Help Context ID:0Step Execution Started: 4/14/2006 1:24:15 PMStep Execution Completed: 4/14/2006 1:24:15 PMTotal Step Execution Time: 0.26 secondsProgress count in Step: 0'O/E/B' is the name of one of the columns in the import text file. 'OEB' is the name of the corresponding column in the SS table. The import file is provided to me by a national vendor; consequently, I can't change the column names before running the DTS process, unless I intervene manually. I wondered if the actual problem was with the column name, or is it masking some other issue? Are there special characters that cannot be used in the column name?Thanks in advance.Dan" |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-19 : 11:01:14
|
| Did u try (if possible) to put O/E/B inside a square bracket as [O/E/B]Srinika |
 |
|
|
|
|
|
DTS Column names