Unable to open BCP error-file

[SURA]

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

[SURA]

Hi All

Issue resolved. Datastage using temp directory for some reason and that DIR was not created was the issue.

So, i created a temp folder and not the job is running good.

Thanks
DS User

[ray.wurlod]

"For some reason" means that's how you - or whoever did the install - configured it. Or failed to. X:\tmp is the default location for the TMPDIR environment variable (where X is the install drive).

When installing on Windows one of the things on your checklist should always be to set up the TMPDIR environment variable and UVTEMP parameter in uvconfig.

[bkamila]

Sura and Ray,
That's correct. Our problem also solved after creating default temp directory. I think that consultant did not follow the book.