Unable to open BCP error-file
Posted: Mon Aug 01, 2011 10:39 pm
Hello All
Just installed the Datastage 8.5 and doing the testing.
DB: SQL Server 2008 R2.
DS: 8.5
When I try to do use SQL Server Enterprise stage using Write method, I am getting SQL Server Enterprise_27,1: HY000 : [Microsoft][ODBC SQL Server Driver]Unable to open BCP error-file error.
But if I change the mode to insert only / other mode in SQL Server Enterprise stage it is working perfectly.
The only issue is when it try to use "sqlsrvrwrite"
Did the SQL Server Enterprise Server Stage will use the ODBC SQL Server Driver?
Is any one had this issue before? Found any solution / workaround!
Please help us too.
Thanks
DS User
Just installed the Datastage 8.5 and doing the testing.
DB: SQL Server 2008 R2.
DS: 8.5
When I try to do use SQL Server Enterprise stage using Write method, I am getting SQL Server Enterprise_27,1: HY000 : [Microsoft][ODBC SQL Server Driver]Unable to open BCP error-file error.
But if I change the mode to insert only / other mode in SQL Server Enterprise stage it is working perfectly.
The only issue is when it try to use "sqlsrvrwrite"
Did the SQL Server Enterprise Server Stage will use the ODBC SQL Server Driver?
Is any one had this issue before? Found any solution / workaround!
Please help us too.
Thanks
DS User