Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS package is scheduledas SQL agent job but while connecting todata sources, it is usingsql agent account to connect , not the connections defined in configurations RE: SSIS package is scheduledas SQL agent job but while connecting todata sources, it is usingsql agent account to connect , not the connections defined in configurations

  • June 11, 2008 at 8:34 am

    #827289

    Don't know if this is what's going on - but it's something to check....

    There are special security considerations when using xp_cmdshell. You can review these in BOL.