When an SSIS package uses SQL server access from sql accounts, the package can be scheduled to run in a job under SQL server agent and everything will work fine. When a Windows account is needed because you have to read/write files from the file system, then either the SQL agent account needs access to those files on a file share or you need a windows account with sufficient access rights to the files. In this last case a proxy account can be used. SQL server agent will use this account to run the package in one of the steps of the job.
How to setup a proxy account and the corresponding credentials is explained in this article from mssqltips
Thursday, April 12, 2012
Run SSIS Package from SQL Server Agent Using a Proxy Account
Subscribe to:
Post Comments (Atom)
1 comment:
hollister, louis vuitton, canada goose outlet, moncler, pandora jewelry, swarovski, louis vuitton, bottes ugg, coach outlet, moncler, supra shoes, montre pas cher, moncler, ugg,uggs,uggs canada, ugg,ugg australia,ugg italia, canada goose, links of london, pandora jewelry, karen millen, doudoune canada goose, juicy couture outlet, moncler, pandora charms, marc jacobs, swarovski crystal, moncler, ugg pas cher, thomas sabo, louis vuitton, moncler outlet, moncler, canada goose, canada goose uk, canada goose outlet, ugg boots uk, juicy couture outlet, wedding dresses, moncler, canada goose, toms shoes, louis vuitton, replica watches, sac louis vuitton pas cher, pandora charms, canada goose
Post a Comment