Forum Replies Created

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

  • RE: Dervied Column conversion from DT_Str to DT_DBTimestamp

    Grateful to both of you for helping out. Thanks!

    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 6:09 am

    #1239615

  • RE: Dervied Column conversion from DT_Str to DT_DBTimestamp

    It was causing all sorts of errors for me, though. Too many to count. I was trying all sorts of variations on the expression.

    LEN() was the magic bullet. I ended...

    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 5:48 am

    #1239597

  • RE: Where are you?

    Chris Morris-439714 (10/20/2010)

    Good Lord Tom, I'd always crossed Lanzarote right off my potential places to visit list because of the British tourism. Your account paints it in a completely new...

    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 5:20 am

    #1239583

  • RE: Dervied Column conversion from DT_Str to DT_DBTimestamp

    Now see, I've tried the ISNULL(effDt) without the == TRUE and while it didn't "bleed", it did error out on me. But then again, I haven't tried the entire line...

    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 5:00 am

    #1239580

  • RE: FTP task when file is not found. A better way to handle....

    Mitch Small (10/19/2010)

    Thanks for your replys. I think what da-zero said makes sense as far as checking to see if the file exists before downloading it.

    Just an FYI: This...

    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:52 am

    #1239575

  • 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

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