Friday, August 26, 2011

SSIS Deployment With SQL Server Agent

(1) . Change SQL Server Agent Log on as Network Service (default is Localsystem) from target sql server configuration manager ( eg. target sql server is colvts02, need to do this work under colvts02)
(2). Using windows Authentication in all SSIS packages.

0 Comments:

Post a Comment

<< Home