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
Unable to open BCP error-file
Moderators: chulett, rschirm, roy
Re: Unable to open BCP error-file
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.