Post reply

Create SSIS Variable from SQL Select Statement

  • June 10, 2011 at 8:59 am

    #1337054

    Deepak_Vad (6/10/2011)

    Also please can you suggest a good book on SSIS? or best method to learn SSIS?

    There's a good beginner's book called "Hands-On Microsoft SQL Server 2005 Integration Services" by McGraw Hill / Osborn (publishers). It's very basic.

    The learning curve on SSIS is very steep to begin with, but once you've banged out about 5-6 packages, you'll find the rest is rather intuitive. I advise just creating packages left and right, using Books Online (it's free), the forums, and looking for Blogs that tell you how build packages (or articles here on SSC).

    Pragmatic Works also does free webinars on Tuesdays & Thursdays which sometimes addresses the basics (but more often, it's intermediate / advanced stuff).

    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.

  • June 10, 2011 at 10:23 am

    #1337113

    It has been a long time since I tried to do this, but I think the script task is the best way to do this.

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

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