Exceute Stored Procedure from SSIS thru .NET Data Provider for Teradata 14.10 5510 error

Connectivity

Exceute Stored Procedure from SSIS thru .NET Data Provider for Teradata 14.10 5510 error

Hi, I am trying to execute a stored procedure from Visual Studio 2012 using the .Net drivers. I am connecting thru LDAP, the character set is UTF8, session mode is ANSI.

In Teradata studio, after running

help procedure xxx.xxxx attributes;

I can see Character set = UTF8  ; platform is UNIX, collation is ASCII, transaction semantics is ANSI.

I can't set the TMODE In ADO connectin string.

There are no parameters, just using Sqlstatement call xxx.samplesp()

With isQuery storedprocedure set to true, no resultset, sqlsourcetpye direct.

It jsut returns with [5510] Invalid session mode for procedure execution. Have tried a few settings

Any ideas please?

3 REPLIES
Teradata Employee

Re: Exceute Stored Procedure from SSIS thru .NET Data Provider for Teradata 14.10 5510 error

Corresponding keyword for .NET provider is "Session Mode" instead of "TMODE".

Re: Exceute Stored Procedure from SSIS thru .NET Data Provider for Teradata 14.10 5510 error

Hi, thanks for taking the time to reply back. I worked around the issue by placing the connection string into a connection expression. Unfortunetly, now I am getting a 5497 CAll cannot be submitted in multi statement request.

I tried it on a blank SP, I tried changing TMODEs etc. But I cannot get SSIS to call a SP using an Execute Sql Task. I can execute using script task. do you know if it is possible to avoid the multi statement error?

thanks in advance

Paul

Teradata Employee

Re: Exceute Stored Procedure from SSIS thru .NET Data Provider for Teradata 14.10 5510 error

Have you tried ODBC?  I ran a few simple SSIS tests and it appears to work when you set ODBC session mode according to how SP was created. Looks like SSIS does not like ANSI session mode w/ .NET. Will look into it.