Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sura
Starting Member
10 Posts |
 Posted - 2011-08-18 : 22:37:59
|
| Hello AllI am using SQL 2008 R2 as my target. IBM Datastage read the data from source and load into SQL Server table. Just now we migrated to new Datastage 8.5 version. In this version i am getting "HY000 - Unable to open BCP error-file " error when the Datastage api tried to load the data using BCP utility.I am not aware of..1. How Datastage trying to call BCP utility.2. I am not sure where Datastage is writing error log (internally)I am aware..I can see a Director (for job log) and in that log i am getting the BCP file error.The user which is trying to load the data is having admin rights.The user for the Datastage is having admin rights in Win 2008 R2 & Datastage.I wish to know.,Is there is any place where i can see the error details from SQL Server point of view. Let me know, if you need more info.Thanks in advanceUser |
|
|
lappin
Posting Yak Master
182 Posts |
Posted - 2011-08-22 : 05:11:18
|
| To see code executed inside SQL Server, you can run a trace:http://databases.about.com/od/sqlserver/ht/trace.htm The "TSQL_Replay" template might be best.You haven't said what the source data is - it might be possible to exclude the IBM Datastage from the process, and have SQL Server get the data directly. |
 |
|
|
|
|
|
HY000 - Unable to open BCP error-file