CODEWITHSUNDEEP
stored-proceduresssisoledbsap-asessis-2012
Ash
Ash

Reputation: 410

SSIS Data flow failing - calling a Sybase ASE stored procedure using temp tables

I have been battling with a SSIS task (2012), which has a series of Data flow tasks run in series.

In particular, there is one data flow task that is failing at the Data Source stage. I am Calling a Sybase ASE (15) stored procedure, using the OLE DB driver. This stored procedure is called via a "Command Via Variable" call.

What is happening is the stored procedure is failing at the end of the Pre-Execution phase, with an "Unable To Retrieve Column Information From The Data Source" error message.

The failure only occurs when I run this from the SQL server (2014) that I have deployed the process to. It appears to run OK in my dev environment (Visual Studio 2012).

The only clue I have at the moment points to the ASE Stored Proc. I have commented out a whole bunch of updates and other proc internal Temp Table populates and it all works fine. I start randomly adding them back and the process fails - there appears to be no rhyme or reason.....

Has anyone come across this issue before? Is there any setting on either SSIS, SQL Server or ASE that I could set that might assist?

Thanks

Upvotes: 0

Views: 562

Answers (1)

Ash
Ash

Reputation: 410

As per my comment above, the issue came down to driver incompatibility between my dev environment and the SQL server that I deployed the SSIS project to.

In short, My dev environment is using the ASE 15.7.0.1260 suite of drivers. The SQL server that I was deploying to had the ASE 15.7.0.501 suite of drivers installed.

Once the SQL server had its drivers updated, all has started working faultlessly.

Upvotes: 0

Related Questions