Execute SSIS Package with the Destination not on a trusted domain

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 2, 2016 at 11:58 am

  #313700

  I created an SSIS package to load a number of tables.

  I'm populating the destination on a Server that is not a trusted domain using a SQL Server account.

  If I were to create a job it is going run as the SQL Server Agent Account?

  How do I get around this?

  Are there other options besides creating a Windows task?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 2, 2016 at 12:13 pm

  #1875980

  I could create a bat file to run dtexec /f C:\SSIS\RefreshXact\RefreshXact.dtsx.

  Does sound like a viable option?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/