intermittent openquery error "..The OLE DB provider MSDASQL indicates that the object has

Help,

I am running a pass through query to oracle from SQL server 2000 as
follows;

select * from openquery(nbsp, 'select * from FND_FLEX_VALUES')

I have run this query through both DTS and the query analyzer and get
the foloowing error;

Server: Msg 7357, Level 16, State 2, Line 3
Could not process object 'select * from FND_FLEX_VALUES'. The OLE DB
provider 'MSDASQL' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to
process object, since the object has no columnsProviderName='MSDASQL',
Query=select * from FND_FLEX_VALUES'].

The really strange thing is, I'll get this error the first time I
execute the query but if I execute it immeadiatley after it will run
fine.

Any help would be most appreciated!

Cheers"Kevin" <kevin.morrell@.nbs.nhs.uk> wrote in message
news:3fff8324.0409150032.783cfd99@.posting.google.c om...
> Help,
> I am running a pass through query to oracle from SQL server 2000 as
> follows;
> select * from openquery(nbsp, 'select * from FND_FLEX_VALUES')
> I have run this query through both DTS and the query analyzer and get
> the foloowing error;
> Server: Msg 7357, Level 16, State 2, Line 3
> Could not process object 'select * from FND_FLEX_VALUES'. The OLE DB
> provider 'MSDASQL' indicates that the object has no columns.
> OLE DB error trace [Non-interface error: OLE DB provider unable to
> process object, since the object has no columnsProviderName='MSDASQL',
> Query=select * from FND_FLEX_VALUES'].
> The really strange thing is, I'll get this error the first time I
> execute the query but if I execute it immeadiatley after it will run
> fine.
> Any help would be most appreciated!
> Cheers

There are a couple of KB articles for error 7357, but they only relate to
situations where the query doesn't return a result set, which doesn't seem
to be the case with your query:

http://support.microsoft.com/defaul...8&Product=sql2k
http://support.microsoft.com/defaul...9&Product=sql2k

Is there some reason why you're using the ODBC OLE DB provider instead of
the Oracle one (MSDAORA)? You might want to try the Oracle one to see if
that makes a difference, and upgrading MDAC to the latest version might also
be worth a try.

Simon

Intermittent ole db error

I have this problem occuring intermittently:

When I try to add a package to the project, and click on the Package path button. I get a oledb error x080004005 (client unable to establish connection)...

After I click ok, and click on the Package path again 2 or 3 times, the error goes away and I get the list of packages displayed. Some time I get an empty list box.

Similar to this happens when I execute a package also. When I execute it 2nd or 3 rd time it works fine. The error happens only when I am trying to connect to the server\database. Once it is in the database I do not get any error message.

This is what I have:

I have sql 2005 installed.

Microsoft SQL Server Management Studio 9.00.1399.00

Microsoft Analysis Services Client Tools2005.090.1399.00

Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

Thank you in advance!!!

Well, what database are you connecting to in your OLE DB connector?|||It should be the msdb database since the ssis packages reside there, right?|||No. What source database are you getting your data from in the data flow?|||

Let me clarify:

I have a project. From the solution explorer window, I right click on "SSIS Packages" and choose "Add Existing Package".

In the window that pops I choose "SQL server" for the "Package Location" and I choose my server name for the "server" and when I click on the button next to the "Package path" I get intermittent ole db errors.

Some times I do not get errors and the list of packages get displayed. Some times it takes one, two or three tries and then I get the list.

Again Thanks for your help.

|||Yes, but what the data flow looks like...what Databases is the apckage using as Source and destination. Also provide the full errror message.|||

There are many packages(about 20) in the server and each package uses different databases in that server. In the problem I explained before I have not yet connected to any package. I am just trying to add a package to my project.

For Example, some package is used to bulk insert a file to a table and for that package source is the "flat file" and the destination is a "Native ole db\sql native client". Again, my problem is not executing the package. The intermittent problem is adding the package to my project.

Thank you.

intermittent OLE DB error

I have this problem occuring intermittently:

When I try to add a package to the project, and click on the Package
path button. I get a oledb error x080004005 (client unable to
establish connection)...

After I click ok, and click on the Package path again 2 or 3 times,
the error goes away and I get the list of packages displayed. Some
time I get an empty list box.

Similar to this happens when I execute a package also. When I execute
it 2nd or 3 rd time it works fine. The error happens only when I am
trying to connect to the server\database. Once it is in the database
I do not get any error message.

This is what I have:

I have sql 2005 installed.

Microsoft SQL Server Management
Studio
9.00.1399.00

Microsoft Analysis Services Client
Tools
2005.090.1399.00

Microsoft Data Access Components
(MDAC)
2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

Thank you in advance!!!(gelangov@.hotmail.com) writes:

Quote:

Originally Posted by

After I click ok, and click on the Package path again 2 or 3 times,
the error goes away and I get the list of packages displayed. Some
time I get an empty list box.
>
Similar to this happens when I execute a package also. When I execute
it 2nd or 3 rd time it works fine. The error happens only when I am
trying to connect to the server\database. Once it is in the database
I do not get any error message.

I have no idea what this may be. However, I noted one thing:

Quote:

Originally Posted by

I have sql 2005 installed.
>
Microsoft SQL Server Management
Studio
9.00.1399.00
>
Microsoft Analysis Services Client
Tools
2005.090.1399.00

This is the RTM version of SQL 2005. There is an SP1 out. There is also an
SP2 in progress, currently a preview of SP2 is available. I would recommend
that you download an install SP1, and that you keep an eye open for the
release of SP2. No promises that it will resolve your problem, though.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thank you, Erland...I will try that!

On Jan 29, 6:07 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(gelan...@.hotmail.com) writes:

Quote:

Originally Posted by

After I click ok, and click on the Package path again 2 or 3 times,
the error goes away and I get the list of packages displayed. Some
time I get an empty list box.

>

Quote:

Originally Posted by

Similar to this happens when I execute a package also. When I execute
it 2nd or 3 rd time it works fine. The error happens only when I am
trying to connect to the server\database. Once it is in the database
I do not get any error message.I have no idea what this may be. However, I noted one thing:

>

Quote:

Originally Posted by

I have sql 2005 installed.

>

Quote:

Originally Posted by

Microsoft SQL Server Management
Studio
9.00.1399.00

>

Quote:

Originally Posted by

Microsoft Analysis Services Client
Tools
2005.090.1399.00This is the RTM version of SQL 2005. There is an SP1 out. There is also an

SP2 in progress, currently a preview of SP2 is available. I would recommend
that you download an install SP1, and that you keep an eye open for the
release of SP2. No promises that it will resolve your problem, though.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Integration services(data flow error)

when executing my data flow package that contains only one source and one destination

OLE db source -> SQL server destination

the following errors occurs in my output

Error: 0xC0202009 at Data Flow Task(infraction action), SQL Server Destination [3600]: An OLE DB error has occurred. Error code: 0x80040E14.

Error: 0xC0202071 at Data Flow Task(infraction action), SQL Server Destination [3600]: Unable to prepare the SSIS bulk insert for data insertion.

Error: 0xC004701A at Data Flow Task(infraction action), DTS.Pipeline: component "SQL Server Destination" (3600) failed the pre-execute phase and returned error code 0xC0202071.

i've checked the structure of my source and destination table but nothing seems to be wrong

if someone have ever faced these errors help me :D

Are you running the package on the same machine as the SQL Server instance that you are inserting into?

If not, it won't work. Use OLE DB Destination instead.

-Jamie

|||I have the same problem and everything is on the same machine. I am transfering from records from multiple tables in one database to a single table in another database. The destinations all have table lock OFF and it usually works. However, recently, I started getting this message. Also, if I rerun it, it happens on different tasks (the tasks are simultaneous 2 at a time).|||

Hi,

I'm having this issue as well, i.e. a package using the "SQL Server Destination" data flow component, loading a server on the same machine (a named instance) that the SSIS package is executing fails with an "Unable to prepare the SSIS bulk insert for data insertion." error. I suspect the windows account executing the package or the SQL login it's mapped to don't have some required permission, but I've tried making the sql account dbo, bulkadmin etc, and added to the local administrators group with no luck. I've seen this reported several times, but no solution?

Dave

|||

Hi guys,

I've mentioned some pre-requisites to getting SQL Server Destination working here:

Destination Adapter Comparison
(http://blogs.conchango.com/jamiethomson/archive/2006/08/14/SSIS_3A00_-Destination-Adapter-Comparison.aspx)

which may or may not be useful. I hope it is.

-Jamie

Integration services(data flow error)

when executing my data flow package that contains only one source and one destination

OLE db source -> SQL server destination

the following errors occurs in my output

Error: 0xC0202009 at Data Flow Task(infraction action), SQL Server Destination [3600]: An OLE DB error has occurred. Error code: 0x80040E14.

Error: 0xC0202071 at Data Flow Task(infraction action), SQL Server Destination [3600]: Unable to prepare the SSIS bulk insert for data insertion.

Error: 0xC004701A at Data Flow Task(infraction action), DTS.Pipeline: component "SQL Server Destination" (3600) failed the pre-execute phase and returned error code 0xC0202071.

i've checked the structure of my source and destination table but nothing seems to be wrong

if someone have ever faced these errors help me :D

Are you running the package on the same machine as the SQL Server instance that you are inserting into?

If not, it won't work. Use OLE DB Destination instead.

-Jamie

|||I have the same problem and everything is on the same machine. I am transfering from records from multiple tables in one database to a single table in another database. The destinations all have table lock OFF and it usually works. However, recently, I started getting this message. Also, if I rerun it, it happens on different tasks (the tasks are simultaneous 2 at a time).|||

Hi,

I'm having this issue as well, i.e. a package using the "SQL Server Destination" data flow component, loading a server on the same machine (a named instance) that the SSIS package is executing fails with an "Unable to prepare the SSIS bulk insert for data insertion." error. I suspect the windows account executing the package or the SQL login it's mapped to don't have some required permission, but I've tried making the sql account dbo, bulkadmin etc, and added to the local administrators group with no luck. I've seen this reported several times, but no solution?

Dave

|||

Hi guys,

I've mentioned some pre-requisites to getting SQL Server Destination working here:

Destination Adapter Comparison
(http://blogs.conchango.com/jamiethomson/archive/2006/08/14/SSIS_3A00_-Destination-Adapter-Comparison.aspx)

which may or may not be useful. I hope it is.

-Jamie

Integration services(data flow error)

when executing my data flow package that contains only one source and one destination

OLE db source -> SQL server destination

the following errors occurs in my output

Error: 0xC0202009 at Data Flow Task(infraction action), SQL Server Destination [3600]: An OLE DB error has occurred. Error code: 0x80040E14.

Error: 0xC0202071 at Data Flow Task(infraction action), SQL Server Destination [3600]: Unable to prepare the SSIS bulk insert for data insertion.

Error: 0xC004701A at Data Flow Task(infraction action), DTS.Pipeline: component "SQL Server Destination" (3600) failed the pre-execute phase and returned error code 0xC0202071.

i've checked the structure of my source and destination table but nothing seems to be wrong

if someone have ever faced these errors help me :D

Are you running the package on the same machine as the SQL Server instance that you are inserting into?

If not, it won't work. Use OLE DB Destination instead.

-Jamie

|||I have the same problem and everything is on the same machine. I am transfering from records from multiple tables in one database to a single table in another database. The destinations all have table lock OFF and it usually works. However, recently, I started getting this message. Also, if I rerun it, it happens on different tasks (the tasks are simultaneous 2 at a time).|||

Hi,

I'm having this issue as well, i.e. a package using the "SQL Server Destination" data flow component, loading a server on the same machine (a named instance) that the SSIS package is executing fails with an "Unable to prepare the SSIS bulk insert for data insertion." error. I suspect the windows account executing the package or the SQL login it's mapped to don't have some required permission, but I've tried making the sql account dbo, bulkadmin etc, and added to the local administrators group with no luck. I've seen this reported several times, but no solution?

Dave

|||

Hi guys,

I've mentioned some pre-requisites to getting SQL Server Destination working here:

Destination Adapter Comparison
(http://blogs.conchango.com/jamiethomson/archive/2006/08/14/SSIS_3A00_-Destination-Adapter-Comparison.aspx)

which may or may not be useful. I hope it is.

-Jamie