Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 9,715 total)

  • RE: SSIS ForEach Loop Container recursion question

    So here's how I got it to work.

    I created two variables, @FileCount (set at 0) and @LoopCounter (set at 1). Using a T-SQL task with the below code,...

    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.

    May 17, 2017 at 11:24 am

    #1942986

  • RE: Are the posted questions getting worse?

    Yes, we could set the reply to but we don't want out of office messages and such hitting our inboxes. So we make them forward the email to us.

    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.

    May 17, 2017 at 5:21 am

    #1942858

  • RE: Are the posted questions getting worse?

    Sorta technical question that is more of the curious variety.

    When you have to set up an automated email from a SQL server job to either a business unit customer...

    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.

    May 17, 2017 at 4:47 am

    #1942849

  • RE: Are the posted questions getting worse?

    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    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.

    May 16, 2017 at 11:02 am

    #1942741

  • RE: SSIS ForEach Loop Container recursion question

    <headdesk>

    Feeling really stupid now.

    I've done this before. Back in 2005 or 2006. This fact finally dawned on me after staying away from this project for a...

    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.

    May 16, 2017 at 10:55 am

    #1942737

  • RE: Are the posted questions getting worse?

    Luis Cazares - Tuesday, May 16, 2017 10:35 AM

    Those are orcas highly trained by Muslims, Russians, and Mexicans to invade the...

    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.

    May 16, 2017 at 10:40 am

    #1942732

  • RE: Are the posted questions getting worse?

    Is it just me or does it seem orcas are getting in on the black market organ market?

    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.

    May 16, 2017 at 7:04 am

    #1942690

  • RE: SSIS ForEach Loop Container recursion question

    Phil Parkin - Friday, May 12, 2017 12:13 PM

    Just to clarify, consistency is not a prerequisite for my suggestion. Only that...

    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.

    May 15, 2017 at 8:10 am

    #1942557

  • RE: SSIS ForEach Loop Container recursion question

    Thom A - Friday, May 12, 2017 7:21 AM

    I was actually planning to use a Script Component and an ADO variable as...

    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.

    May 12, 2017 at 12:06 pm

    #1942379

  • RE: SSIS ForEach Loop Container recursion question

    FridayNightGiant - Friday, May 12, 2017 11:33 AM

    I've done something similar in the past, here is some sample code I mocked up

    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.

    May 12, 2017 at 12:01 pm

    #1942377

  • RE: SSIS ForEach Loop Container recursion question

    Phil Parkin - Friday, May 12, 2017 5:47 AM

    If you know the absolute maximum number of rows in the source, you could...

    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.

    May 12, 2017 at 12:00 pm

    #1942376

  • RE: SSIS ForEach Loop Container recursion question

    Eirikur Eiriksson - Friday, May 12, 2017 5:28 AM

    Are you exporting the data from a table?
    😎

    Yes. I've got a table with...

    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.

    May 12, 2017 at 11:59 am

    #1942375

  • RE: SSIS ForEach Loop Container recursion question

    Thanks, Guys. I'm going to watch this thread for a little bit more (I want to hear what Thom has to say) before digging back into this. I've been banging...

    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.

    May 12, 2017 at 5:22 am

    #1942300

  • RE: Are the posted questions getting worse?

    Thanks, Thom.

    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.

    May 12, 2017 at 5:19 am

    #1942299

  • RE: Are the posted questions getting worse?

    I could use a little bit of SSIS brainstorming assistance over here if someone wouldn't mind. This one has me kind of stumped.

    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.

    May 12, 2017 at 5:02 am

    #1942295

Viewing 15 posts - 991 through 1,005 (of 9,715 total)