October 3, 2011 at 7:07 am
HI Experts,
We are doing Migration of sql server 2000 to 2008, we have some dts packages which copies data from sql server to Syabse server using BCP command!
Now from Sql server 2008 we are able to run BCP command to populate sql table data into text file but the BCP command is not working for loading data from text file to Sybase table
We are running both BCP command from SQL server 2008 package! below is error
[Execute SQL Task] Error: Executing the query "declare @bcp varchar(255)
select @bcp = "d:\Sybas..." failed with the following error: "[Native Error code: 11488]
[DataDirect ADO Sybase Provider] User access denied. Not a member of NT administrators group.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
When I tried from sql server command prompt it gives below error
"directory service layer internal directory control layer error requested server name not found"
Is anybody having idea? it will be a great help for us!
Thanks,
October 4, 2011 at 1:39 am
Hi,
We have solved this problem by replacing our domain ID with SQL Service account, now its working fine.
Thanks,
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply