Forum Replies Created

Viewing 15 posts - 7,156 through 7,170 (of 9,720 total)

  • RE: SSIS Data Flow Error - Global\DTSQLIMPORT

    But if you aren't on the same server, does SSIS always skip past the Source and go straight to the Destination during Debug?

    Or am I just seeing strange behavior?

    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.

    October 20, 2010 at 4:49 am

    #1239572

  • RE: Dervied Column conversion from DT_Str to DT_DBTimestamp

    Steve,

    I don't think IF...THEN...ELSE works in SSIS. That's why I'm trying to use the ? : conditional. And it's not evaluating correctly...

    I'm trying to format an 8 character string into...

    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.

    October 20, 2010 at 4:43 am

    #1239569

  • RE: Where are you?

    Tom.Thomson (10/19/2010)

    Some of the things to see or do on LZ:

    I'm a little brain-dead this morning. LZ?

    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.

    October 20, 2010 at 4:39 am

    #1239565

  • RE: Today's Random Word!

    Foresight

    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.

    October 20, 2010 at 4:37 am

    #1239562

  • RE: More efficient way

    Bill_CCAC (10/19/2010)

    Hi All. I'm hoping for ideas on how to make either my query more efficient of a better way of collecting the same result set. This query currently takes...

    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.

    October 19, 2010 at 11:39 am

    #1239238

  • RE: Where are you?

    There was a museum downtown in the basement of one of the downtown office buildings, many moons ago. Which one is 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.

    October 19, 2010 at 11:34 am

    #1239233

  • RE: Where are you?

    John Rowan (10/19/2010)

    The Railroad museum is the Durham Museum.

    Isn't Durham downtown?

    There's one on 10th or 13th... (10th, I think) when you're heading out of downtown and towards Bellevue. It actually...

    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.

    October 19, 2010 at 11:13 am

    #1239216

  • RE: SSIS Script Component Issue

    I'm not really good with the scripting code, but I have an alternate suggestion. 2, actually.

    Pull the data into a temp table with an identity field and then use 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.

    October 19, 2010 at 11:08 am

    #1239214

  • RE: Where are you?

    John Rowan (10/19/2010)

    Let's see...things to do near Omaha.

    Besides that, Omaha has an outstanding Zoo.

    Henry Doorly (sp) Zoo. Beautiful place.

    Fontinelle Forest (for hiking)... Lots of huge parks in the area....

    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.

    October 19, 2010 at 10:31 am

    #1239188

  • RE: Where are you?

    crookj (10/19/2010)

    Garden of the Gods

    Been there. Beautiful place.

    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.

    October 19, 2010 at 10:26 am

    #1239183

  • RE: Calling a Stored Procedure inside a stored procedure

    Marv-1058651 (10/19/2010)

    I would love to add some results and ddl, but unforutantely, I am dealing with patient data. I can dump some dummy data to display instead. Here is 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.

    October 19, 2010 at 10:25 am

    #1239181

  • RE: How to create new instance in sql server 2005

    That right there might be the problem. I don't know if SQL Agent is actually needed for the install, 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.

    October 19, 2010 at 10:23 am

    #1239177

  • RE: Are the posted questions getting worse?

    I would just like to let everyone know that I live very green.

    My sheets are green, my clothes are green, my food is green, my cats are green... Oh, wait....

    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.

    October 19, 2010 at 10:21 am

    #1239175

  • RE: Horror stories for Halloween

    davidandrews13 (10/19/2010)

    Brandie Tarvin (10/15/2010)

    Not a horror story, but definitely a cringe moment.

    A job where the Dev instance was on the same server as the Production Instance. SQL Security was not...

    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.

    October 19, 2010 at 10:18 am

    #1239174

  • RE: Dead lock on Collection Set

    Roy,

    What is it deadlocking?

    What exactly is the question? @=)

    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.

    October 19, 2010 at 10:13 am

    #1239166

Viewing 15 posts - 7,156 through 7,170 (of 9,720 total)