Gowey Mike W
Mike.W.Gowey at doc.state.or.us
Mon Sep 18 15:53:49 CDT 2006
This is the full error that it gives in the debug window: [Destination - tblInventory [193]] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". [Destination - tblInventory [193]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid. [DTS.Pipeline] Error: component "Destination - tblInventory" (193) failed the pre-execute phase and returned error code 0xC0202025. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W Sent: Monday, September 18, 2006 2:34 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Import error I just created a package using the SSIS Import\Export Wizard. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Monday, September 18, 2006 2:32 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Import error what is the command you are using? On 9/18/06, Gowey Mike W <Mike.W.Gowey at doc.state.or.us> wrote: > > > Would anybody know why I would get the following error when trying to > import some records from one table to another in the same database. I > am using SQL 2005. > > Cannot create an OLE DB accessor. Verify that the column metadata is > valid. > > > Thanks, > > Mike Gowey MCP, MCDST, A+, LME, NET+ > Team Leader - SouthEast Region > Information Systems Unit > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco http://sqlthis.blogspot.com | Tsql and More... _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com