Another question. Once I finish writing up the Powershell script, how do I make it part of the SSIS package or the SQL Server Agent job?
Is it as simple as calling it in a .bat file or using the Execute Process Task?
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.