Forum Replies Created

Viewing 15 posts - 481 through 495 (of 1,034 total)

  • RE: How to: Fail Lookup Transformation if matches are found

    Triality (1/10/2012)

    That is a good idea, but how do I make sure the error is raised before any of the no match output rows are added to the database?

    Make the...

    January 10, 2012 at 12:13 pm

    #1431353

  • RE: How to: Fail Lookup Transformation if matches are found

    Triality (1/10/2012)

    I could do that, but I am loading about 30 different files on this package all with different layouts. I would have to create 30 additional "error" tables...

    January 10, 2012 at 9:56 am

    #1431282

  • RE: How to: Fail Lookup Transformation if matches are found

    Triality (1/10/2012)

    I see how to fail the lookup transformation if matches are NOT found, but is it possible to also fail the lookup transformation if matches ARE found? I...

    January 10, 2012 at 9:49 am

    #1431276

  • RE: Incremental Data Load

    Koen Verbeeck (12/16/2011)

    ChiragNS (12/16/2011)

    Hi

    Does the source table that you populate your data from have a identity column as the primary key ?

    If so you can take the max of that...

    January 10, 2012 at 9:43 am

    #1431271

  • RE: Time Zone

    Oracle supports storing timezone with dates.

    http://docs.oracle.com/cd/B14117_01/server.101/b10759/functions179.htm

    Using the portability defense really isn't a good idea... each DB server is different enough, that queries that can run on all of them, likely...

    January 10, 2012 at 9:29 am

    #1431258

  • RE: Time Zone

    It is also nice when you want to look at all the values relative to your current timezone. For instance, all the logging data goes into the table from...

    January 10, 2012 at 8:56 am

    #1431232

  • RE: Concurrent Operations

    Yay! For a change one I didn't have to think about, because I actually knew the answer.

    Such a warm and fuzzy feeling... 🙂

    December 15, 2011 at 6:50 am

    #1421911

  • RE: Truncation Error from the following logic

    john.arnott (12/9/2011)

    Mark,

    Is the error message completely unambiguous? Or is it possible that some other column is what's getting truncated? "Truncation" makes it sound like a character...

    December 9, 2011 at 1:45 pm

    #1419618

  • RE: Truncation Error from the following logic

    Evil Kraig F (12/9/2011)

    mtassin (12/8/2011)

    I did... that's where the dates and times from above come from. 🙂

    D'oh, *facepalm*. Sorry.

    I'm wondering if this is a case of SSIS complaining...

    December 9, 2011 at 12:55 pm

    #1419587

  • RE: Truncation Error from the following logic

    john.arnott (12/7/2011)

    I've not tried anything to prove this, but it seems that if you 're converting a string to DT_DBTime, the string should be in the format of hh:mm:ss. ...

    December 8, 2011 at 6:52 am

    #1418661

  • RE: Truncation Error from the following logic

    Evil Kraig F (12/7/2011)

    mtassin (12/7/2011)

    Of 11million records... about 50,000 are failing with truncation. Near as I can tell there's no way I'm exceeding the bounds of a DT_I4 data...

    December 8, 2011 at 6:50 am

    #1418659

  • RE: Output Parameter

    Ninja's_RGR'us (11/21/2011)

    mtassin (11/21/2011)

    Ninja's_RGR'us (11/21/2011)

    I know it depends, but I'm getting sick of making that argument so I was hoping one of you guys would take care ot that! 😉

    IT DEPENDS!

    There...

    November 21, 2011 at 7:40 am

    #1410724

  • RE: Output Parameter

    Ninja's_RGR'us (11/21/2011)

    I know it depends, but I'm getting sick of making that argument so I was hoping one of you guys would take care ot that! 😉

    IT DEPENDS!

    There I did...

    November 21, 2011 at 7:05 am

    #1410691

  • RE: Heath Normal Form

    Hugo Kornelis (11/14/2011)

    martin.whitton (11/14/2011)

    I never use BI in my work. Yet, I like QotD questions about BI, because they force me to look into technology I normally don't use, and...

    November 14, 2011 at 7:38 am

    #1407158

  • RE: SQL_VARIANT 1

    I woulda had it right, but I thought I'd double check myself. Since I was using SQL 2008 R2, I figured I'd use the new way to do inserts...

    November 10, 2011 at 7:02 am

    #1405722

Viewing 15 posts - 481 through 495 (of 1,034 total)