Forum Replies Created

Viewing 15 posts - 8,836 through 8,850 (of 9,715 total)

  • RE: I got burned today at a SQL Server Interview!

    Hey, don't Lab Rats get cheese when they thread the maze correctly?

    Where's mine??? I want CHEDDAR!!!

    @=)

    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.

  • RE: I got burned today at a SQL Server Interview!

    Mark,

    What we were willing to do was to tell you not to lie and how to improve your skills so you wouldn't have to lie. Yet you seemed to...

    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.

  • RE: I got burned today at a SQL Server Interview!

    Lynn,

    Good catch!

    I know my manager has been known to Google prospects before doing the phone interview. In fact, he did it just a few weeks ago on the last...

    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.

  • RE: I got burned today at a SQL Server Interview!

    It definitely makes me wonder about the "manager is a Nazi" comment if he lies to get into the job, then admits his first week he was hanging out and...

    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.

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

    Whenever I see that problem, it's because people are trying to use SSIS to pull data into a 2000 destination from a 2005 source. Unfortunately, SQL 2000 doesn't recognize...

    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.

  • RE: OLEDB source does not see SP CTE Fields

    So far the only resolution I have found is to stick an Execute SQL Task right before my Data Flow, modify the Proc to stick the data in a real...

    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.

  • RE: OLEDB source does not see SP CTE Fields

    That's pretty much what I did the first time. Did it again and got the same error message. I'm wondering if it's a combination of the CTEs and...

    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.

  • RE: OLEDB source does not see SP CTE Fields

    I tried following your suggestion and got an immediate failure.

    Error message is: Column "MyColumn" cannot be found at the datasource.

    The OLE DB Source has ValidateExternalMetaData set to false. It...

    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.

  • RE: Lookup Transformation Case Sensitivity Question

    Michael, thanks for the correction. For some reason I really thought it wouldn't allow FULL OUTER.

    Paul, really? Everything I've read said that partial & no caching is much...

    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.

  • RE: OLEDB source does not see SP CTE Fields

    BTW, Pretty sure the issue is the temp table myself since I tried redoing the proc with only the Temp table and not the CTE. Got the same "blank...

    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.

  • RE: OLEDB source does not see SP CTE Fields

    So, once I get everything properly set up, saving the ValidateExternalMetaData to False will allow the package to run?

    I hadn't tried using a Proc stub, so of course I 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.

  • RE: Lookup Transformation Case Sensitivity Question

    I've actually changed my two sources to two different dataflows that end up in the same destination staging table.

    Unfortunately, while both sources do have crossover records, both sources also have...

    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.

  • RE: Testing ConditionalSplit vs Server-Side WHERE clause

    John,

    Actually, there wasn't much processing going on after the Split. And over the weekend, I just discovered what you're referring to (even though I didn't read your post until 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.

  • RE: Lookup Transformation Case Sensitivity Question

    Michael,

    The problem is that I'm working on "staging the data" right now. I've already got everything in two separate SQL DBs (mainframe uploaded to SQL and the SQL...

    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.

  • RE: Testing ConditionalSplit vs Server-Side WHERE clause

    Ah, well that would explain a lot.

    Right now I'm still in Dev & Debug mode. But I guess it wouldn't hurt to disable everything but the container I'm currently...

    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.

Viewing 15 posts - 8,836 through 8,850 (of 9,715 total)