OleDBProperty 'Column Metadata Array' already exists in the collection.

Last Post 16 Jun 2006 09:29 AM by dbandee. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sanjayattray
New Member
New Member

--
17 May 2006 10:28 AM
I get this error when I execute DTS package second time. on first run it runs smoothly and moves all data from my text file. Second time it says 'Column Metadata Array' already exists in the collection. Am i missing something here. Can some one please help me out in this. Here I am using global variable in DTS package.

Error:

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147220500 (800403EC)
Error string: OleDBProperty 'Column Metadata Array' already exists in the collection.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error Detail Records:

Error: -2147220500 (800403EC); Provider Error: 0 (0)
Error string: OleDBProperty 'Column Metadata Array' already exists in the collection.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.
NULL

Error:Error:Error:
dbandee
New Member
New Member

--
16 Jun 2006 09:29 AM
what are u tryint to do? importing text file into SQL Table (existing or new)?
You are not authorized to post a reply.

Acceptable Use Policy