Load sybase table from SQL server 2008 using BCP command

• xparmanand

  SSC Eights!

  Points: 957

  More actions

  October 3, 2011 at 7:07 am

  #244760

  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,

• xparmanand

  SSC Eights!

  Points: 957

  More actions

  October 4, 2011 at 1:39 am

  #1389966

  Hi,

  We have solved this problem by replacing our domain ID with SQL Service account, now its working fine.

  Thanks,