SQL Server (DRS) stage error

swades · Post by **swades** » Mon Apr 07, 2008 7:19 am

Hi All,

I am getting following error log while loading to SQL server DB using DRS stage.

Dynamic_RDBMS_8,0: Warning: Audit_job.Dynamic_RDBMS_8: [DataDirect][ODBC SQL Server Driver]20172

Dynamic_RDBMS_8,0: Failure during execution of operator logic.

Dynamic_RDBMS_8,0: Fatal Error: Fatal: SQLBindParameter: Failed to bind a parameter.

node_node1: operator [Dynamic_RDBMS_8], partition 0 of 1, processID 16849 on node1, player 2 terminated unexpectedly.

Any idea please?

Thanks.

chulett · Post by **chulett** » Mon Apr 07, 2008 9:33 am

User-defined SQL?

DSguru2B · Post by **DSguru2B** » Mon Apr 07, 2008 9:36 am

Do you have BigInt as any of your target datatypes?

swades · Post by **swades** » Mon Apr 07, 2008 9:40 am

chulett wrote:User-defined SQL?

I tried both way USER DEFINED and AUTO GENERATED SQL

swades · Post by **swades** » Mon Apr 07, 2008 9:42 am

DSguru2B wrote:Do you have BigInt as any of your target datatypes?

I Have Int(10), varchar(50), char(5), timestamp(32)

swades · Post by **swades** » Sat Apr 26, 2008 5:34 pm

This issue has been resolved :D . Actually in my Target SQL server table two columns are defined as datetime , Before, I was defining this two column as Timestamp in my DS job. I changed to char now its working fine.

I created new server job.
SQL type :- Auto Generated