Forum Replies Created

Viewing 15 posts - 5,266 through 5,280 (of 9,726 total)

  • RE: insert variable value into table while mapping ssis

    We need a little more information to answer your question.

    How is the variable populated?

    How does the variable relate to the .csv file?

    How is the .csv file getting imported? (what...

    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.

    September 16, 2011 at 7:40 am

    #1382541

  • RE: SSIS Event Handler Duplicates Event

    Really? I had never heard that before.

    I am setting the property and we will see what happens.

    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.

    September 15, 2011 at 12:21 pm

    #1382202

  • RE: Insert Into temp table and then copy into 'real' table

    l.danks (9/15/2011)

    To answer one question - the data is entered regularly, every few minutes in fact, but in a format which is less than useless for reporting (just lousy software...

    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.

    September 15, 2011 at 10:50 am

    #1382149

  • RE: SSIS Event Handler Duplicates Event

    How would Delay Validation being set to False force the email to send twice?

    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.

    September 15, 2011 at 6:50 am

    #1381896

  • RE: Insert Into temp table and then copy into 'real' table

    A couple of things.

    1) If you're deleting everything from the destination, use TRUNCATE rather than DELETE. TRUNCATE generally runs faster because it does not fully log the rows being...

    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.

    September 15, 2011 at 6:41 am

    #1381887

  • RE: You'd think I'd have learned...

    Ninja's_RGR'us (9/14/2011)

    Brandie Tarvin (9/14/2011)

    Speaking of school, last night I got so excited about such a silly thing. My SO & I were talking about Decartes and I asked, "He was...

    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.

    September 14, 2011 at 9:36 am

    #1381407

  • RE: You'd think I'd have learned...

    Speaking of school, last night I got so excited about such a silly thing. My SO & I were talking about Decartes and I asked, "He was a rationalist, wasn't...

    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.

    September 14, 2011 at 9:31 am

    #1381403

  • RE: You'd think I'd have learned...

    Ray K (9/14/2011)

    True story: a few weeks ago, I was administering a final exam (I teach part-time). One of my students asked a question. It went something like...

    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.

    September 14, 2011 at 9:24 am

    #1381393

  • RE: BIDS - Uncouple Variables and Toolbox

    You rock, Dave23! Your Google-Fu is superior to mine.

    That actually worked. I moved my Toolbox and no error when I closed BIDS. I open it up and it's exactly where...

    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.

    September 12, 2011 at 11:33 am

    #1380233

  • RE: BIDS - Uncouple Variables and Toolbox

    After experimenting several times, I finally noticed a pattern. If I close BIDS out as normal (without moving the Toolbox), everything shuts down fine, no issues.

    If I move the Toolbox...

    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.

    September 12, 2011 at 10:41 am

    #1380201

  • RE: BIDS ForEach Enumerator is Blank

    HowardW (9/9/2011)

    Actually, this is definitely a UI bug. It looks like it's selected when you create a new one, but it's not behind the scenes.

    Are you having the same...

    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.

    September 9, 2011 at 10:16 am

    #1379389

  • RE: BIDS ForEach Enumerator is Blank

    Howard, that's brilliant! It worked.

    Thank you so very much. I was about to start developing in 2005 and then upgrade.

    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.

    September 9, 2011 at 10:15 am

    #1379386

  • RE: BIDS - Uncouple Variables and Toolbox

    And yet, it's not permanent. The Toolbox keeps moving back to the bottom of my screen when I restart VS.

    This is annoying!

    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.

    September 9, 2011 at 6:29 am

    #1379164

  • RE: Mass Add of SSRS Columns

    Bleargh. I hate using the Wizard. It always gets things wrong.

    Edit: Thanks for the suggestion, though.

    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.

    September 9, 2011 at 6:17 am

    #1379148

  • RE: How to ensure a job only runs for a set duration?

    So far as I know, you can't.

    You could test rebuilding various indexes, though, and break the job up into smaller parts, only running one of those parts each day. 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.

    September 9, 2011 at 5:00 am

    #1379119

Viewing 15 posts - 5,266 through 5,280 (of 9,726 total)