Forum Replies Created

Viewing 15 posts - 8,821 through 8,835 (of 9,715 total)

  • RE: Synonym help needed

    AHHA! I knew I had to be missing something.

    Thanks, Guys. That clears things 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 7, 2008 at 12:44 pm

    #812009

  • RE: OLEDB source does not see SP CTE Fields

    BTW, thanks to all who replied to this thread. Your help has been greatly appreciated.

    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 7, 2008 at 12:39 pm

    #812006

  • RE: OLEDB source does not see SP CTE Fields

    I don't want to put the entire SQL in my source because of SDLC issues. Every time I have to edit an SSIS package, I have to do all...

    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 7, 2008 at 12:38 pm

    #812005

  • RE: Synonym help needed

    It might be. I have to test it.

    Interestingly enough, when setting up Linked SQL Servers in the 2005 GUI, it doesn't allow you to assign a different name than...

    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 6, 2008 at 9:02 am

    #811273

  • RE: Synonym help needed

    This is odd. I could swear I've heard people talk about creating synonyms for their Linked Servers....

    I guess I have more research to do.

    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 6, 2008 at 7:49 am

    #811205

  • RE: Lookup Transformation Case Sensitivity Question

    The things we learn, even when we "think" we know it all. @=)

    Ditto on the thanks, Paul. You're a good source of info.

    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.

    April 18, 2008 at 11:51 am

    #804514

  • RE: xpsmtp80.dll PROBLEMS

    Bill,

    Have you tried the other possible resolutions on this thread already?

    If so, search TechNet (Microsoft's web site). If the ticket was called in and resolved, there might be 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.

    April 18, 2008 at 10:15 am

    #804476

  • RE: Just another controversial topic

    Wow. I start my best topics when I'm tired. @=) This is such a fun one!

    Beer with me. I Brin trying to remember All-gauer Emmentaler the cheese...

    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.

    April 18, 2008 at 8:52 am

    #804416

  • RE: Using UNION ALL before a MERGE JOIN has IsSorted Property Error

    MERGE has the same problem after a UNION ALL. It doesn't think the sources are sorted. And the idea behind using a MERGE JOIN was to compare records...

    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.

    April 18, 2008 at 6:00 am

    #804269

  • RE: Using UNION ALL before a MERGE JOIN has IsSorted Property Error

    Thanks for the ideas, guys. I appreciate the input.

    Now I just have to test it.

    [edit] BTW, where exactly is the UNION component that is not a UNION ALL? ...

    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.

    April 18, 2008 at 4:46 am

    #804219

  • RE: Lookup Transformation Case Sensitivity Question

    Paul,

    Thank you so much for the link. It is greatly informative. And BOL wasn't the only place I saw the stuff on Full Caching. There are 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.

    April 18, 2008 at 4:43 am

    #804218

  • RE: OLEDB source does not see SP CTE Fields

    Michael,

    Thanks for the redone CTE thing. I'm still learning a lot about these.. But are you able to do a double CTE and still get the fields? Because...

    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.

    April 18, 2008 at 4:36 am

    #804212

  • RE: Just another controversial topic

    guh-ROAN!!!!

    @=)

    Good one, though. (hee)

    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.

    April 17, 2008 at 7:35 pm

    #804075

  • RE: Using UNION ALL before a MERGE JOIN has IsSorted Property Error

    Grrr. That's annoying.

    Do you know of anyway to sort the output of a UNION ALL? I can't find one, but that doesn't necessarily mean anything.

    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.

    April 17, 2008 at 9:10 am

    #803799

  • RE: Connection Manager problems with SQL 2000 database and SSIS

    You're welcome. Always glad to help.

    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.

    April 17, 2008 at 9:08 am

    #803796

Viewing 15 posts - 8,821 through 8,835 (of 9,715 total)