xp_cmdshell problem when running an SSIS package

• pjlewis

  Say Hey Kid

  Points: 712

  More actions

  April 21, 2009 at 10:55 am

  #130202

  The message being received is:

  Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80040E4D (Login failed for user 'XXXXXX\YYYYYY$'.)...

  XXXXXX is our Domain Name

  YYYYYY is our server name (note that it reads SVRNAME$ as the user id)

  When I imported the original text file into a SQL Server 2005 table, I saved as an SSIS package. It ran to conclusion. If I create a job with the SSIS package it also runs successfully.

  The problem occurs when I attempt to execute this SSIS package from within a stored procedure.

  Has anyone else encountered this problem.

• Sudiendra

  SSCommitted

  Points: 1839

  More actions

  April 21, 2009 at 11:11 am

  #981641

  I faced some issue with xp_cmdshell, not a similar one though, may be below link might help you

  http://www.sqlservercentral.com/Forums/Topic682723-146-1.aspx#bm682857

  It solved the problem for me..

  Thanks,

  Sudhie.