Forum Replies Created

Viewing 15 posts - 241 through 255 (of 5,678 total)

  • RE: SSIS help in deriving negative values

    Well, as I mentioned, it gets messy...

    The problem here is that you have to consider this a multi step process.

    1) You have to get the letter by itself.

    2) You have...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: SSIS help in deriving negative values

    rkota2008 (7/16/2014)


    Hi,

    '1047383658000012345678990000002014083J354310020140850000005335R0000'

    In this string '0000005335R' is the amount with 2 decimals 000000533.5R

    We need to decode A = 1, B= 2 till I = 9 and J = 1 with...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: ERROR when Executing a Job within SQL Server Agent from an SSIS package. SQL Server 2012, Visual Studio 2010

    Apologies, I forget not everyone has beaten their heads on authentication before. Oops.

    I have no idea what cURL is or any of that, unfortunately. I couldn't tell you what's...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: ERROR when Executing a Job within SQL Server Agent from an SSIS package. SQL Server 2012, Visual Studio 2010

    The exit code comes from something in the .bat file, not SSIS. My guess is you've got a double-hop of some kind going on, messing with the rights to...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    Sean Lange (7/16/2014)


    Lynn Pettis (7/16/2014)


    patrickmcginnis59 10839 (7/16/2014)


    Jack Corbett (7/16/2014)


    Eirikur Eiriksson (7/16/2014)


    No implied either, my respect on handling the situation! So far, JC is the only one that has...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: SSIS Data Flow "bulk insert" VS. INSERT INTO

    When he did his test, did he use the same source data? When he did, did he remove the new data (or changes) from the target table? I...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/16/2014)


    Anybody? Can anybody please step in again and try helping me with WC? Frustrated, can't seem to get him to realize I just don't know what...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: SSIS - centralized or distributed?

    I'm a proponent of the centralized SSIS server, but mostly because of organization and not having to worry about if you found all the pull subscribers out there. If...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: SSIS Data Flow "bulk insert" VS. INSERT INTO

    below86 (7/15/2014)


    The concern I'm hearing is the overall size of the transactional log. And that doing the 'Insert' into these tables using the SSIS dataflow does not add to...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/15/2014)


    Miss me?

    Only because I forgot to calibrate the tranquilizer gun for more windage due to the slower dart at range...

    ... welcome back. 😉


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: output date to mm/dd/yyyy

    is250sp (7/10/2014)


    I already have CONVERT( VARCHAR(10), column, 101) in my SQL command in my OLE DB Source. Also in my Flat File Connection Manager, the Properties for that column...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: finding gaps between termination date and next enrollment date and filter by gap >= 45 days for year 2013

    Tammy-274861 (7/10/2014)


    The member 88888ANTHONY doesn't meet the requirements, because even though he is enrolled for 2013, he has a bigger than 45 days gap between 2013-05-31 00:00:00.000 and 2013-10-01 00:00:00.000.

    That...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Short Join Syntax?

    autoexcrement (7/10/2014)


    I swear I remember reading somewhere about an alternate, shorter JOIN syntax in cases where the column being joined has the same name in both tables. But I can't...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    ChrisM@Work (7/10/2014)


    Koen Verbeeck (7/10/2014)


    Jack Corbett (7/10/2014)


    Koen Verbeeck (7/10/2014)


    So I tried to endorse Jeff on LinkedIn for BCP, but somehow it doesn't work.

    I saw Jeff was endorsed 9 times...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: output date to mm/dd/yyyy

    Track the metadata in the flow and determine where you switch from DBDate to String (or if you even do).

    If you don't, and it's DBDate from beginning to end, the...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 15 posts - 241 through 255 (of 5,678 total)