Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Data Pump

Status
Not open for further replies.
raa44634

raa44634

Technical User
Dec 13, 2001
34
0
0
US
Working on executing a DTS package from ADP. Using the VB file generated by enterprise manager, importing that into an ADP module. Reference thread958-848668

The package picks up a flat file on C:\ and appends it to an existing table on the server. The process executes but terms with the error "...DTS Data Pump. Column name...was not found."

My issue is that the column appears both in the source file (first row is column names; tab delimited) as well as the destination table...so I'm not so sure where it is going awry.

Anyone encounter and how was it resolved? Some quiry syntax?

Thanks

 
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Use domain accounts to log in to Access database
Replies
0
Views
111
breezett93
breezett93
batteam
  • Locked
  • Question
Importing Excel data to SQL table using MSAccess .adp
Replies
3
Views
101
lameid
lameid
Baesucks
  • Locked
  • Question
Trying to insert data from a table in another database
Replies
3
Views
56
lameid
lameid
LeonAtRC
  • Locked
  • Question
Import/Export data by type
Replies
2
Views
41
LeonAtRC
LeonAtRC
sparkbyte
  • Locked
  • Question
Data Validation question
Replies
7
Views
59
sparkbyte
sparkbyte

Part and Inventory Search

Sponsor

Back
Top