Post reply

Running SSIS Package in scheduled job

  • 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

  • October 15, 2018 at 5:03 am

    #2009565

    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.

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

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