Running SSIS Package in scheduled job

Question

Post reply

Running SSIS Package in scheduled job

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

sindhupavani123 Right there with Babe Points: 754 More actions · Answer 1

sindhupavani123

Right there with Babe

Points: 754

October 15, 2018 at 4:53 am

#2009561

Hi ,

Haven't used SSIS Package as I still had issues , selected TSQL in SQL Agent and wrote a Stored procedure instead.

Regards,
Sindhu

Brandie Tarvin SSC Guru Points: 172918 More actions · Answer 2

sindhupavani123 - Monday, October 15, 2018 4:53 AM

Hi ,

Haven't used SSIS Package as I still had issues , selected TSQL in SQL Agent and wrote a Stored procedure instead.

Regards,
Sindhu

Ah. Okay.

Sometimes SSIS is overkill. If you could do what you needed in one stored procedure, you really didn't need an SSIS package. But if I were you, I recommend still playing with SSIS until you figure out where things went wrong. Sometimes the way we learn best is by making mistakes and figuring out how to resolve them.

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.