[dba-SQLServer] Import error

I have to start up my 2005 system to find out why you are receiving
this problem.

On 9/18/06, Gowey Mike W <Mike.W.Gowey at doc.state.or.us> wrote:
> 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
>
> _______________________________________________
> 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...