Forum Replies Created

Viewing 15 posts - 16 through 30 (of 3,232 total)

  • RE: part of an

    Reported as spam

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 16, 2016 at 3:15 pm

    #1912927

  • RE: How did he give you drugs that never existed

    reported as spam

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 11, 2016 at 12:15 pm

    #1911980

  • RE: How to copy entire Solution from one drive to another, rename, and all paths adjust accordingly

    Phil Parkin (9/30/2016)

    quinn.jay (9/30/2016)

    John Rowan (9/30/2016)

    All you need are the .dtsx files. If you need to open them in a solution for editing, create a new project in Visual...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 30, 2016 at 10:07 am

    #1904204

  • RE: How to copy entire Solution from one drive to another, rename, and all paths adjust accordingly

    Again, I'm not sure why you think you need to move a solution. All you need are the .dtsx files. Move those to a network location where you...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 30, 2016 at 6:27 am

    #1904137

  • RE: How to copy entire Solution from one drive to another, rename, and all paths adjust accordingly

    The solution files are only needed for development. Once you've built the package into it's .dtsx file, the solution is really not needed. Your job is not calling...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 29, 2016 at 2:52 pm

    #1904049

  • RE: SP inserts into table

    Jeff Moden (9/20/2016)

    John Rowan (9/20/2016)

    mcfarlandparkway (9/20/2016)

    I completely agree.This is very horrible code. which was written by old people.

    Even I wonder after seeing this code..

    Old people should not be allowed to...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 21, 2016 at 7:34 am

    #1902156

  • RE: How do I get a substring out from a string?

    Borrowing from Alan's example, the same thing can be done w/o the split function. The split may be faster on huge datasets, but I think just using CROSS APPLY...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 20, 2016 at 3:23 pm

    #1902042

  • RE: Should these be in a JunkDimension

    I'd go ahead an put a Role dimension in the model. Load it up with the valid roles and add a RoleID column in your fact table. Create...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 20, 2016 at 3:01 pm

    #1902036

  • RE: SP inserts into table

    mcfarlandparkway (9/20/2016)

    I completely agree.This is very horrible code. which was written by old people.

    Even I wonder after seeing this code..

    Old people should not be allowed to write SQL code...:-D

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 20, 2016 at 2:57 pm

    #1902034

  • RE: Reference to non-existent column does not error

    I've been doing this for a long time, crazy that I've never seen this before. Of course, I always use aliases so maybe my good coding practices have just...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    July 14, 2016 at 7:54 am

    #1890118

  • RE: date Hierarchy (simple hopefully)

    Yes. If you can do this on the physical tables, great. Otherwise, use a Named Query in the DSV to create these columns.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 29, 2016 at 12:49 pm

    #1887704

  • RE: date Hierarchy (simple hopefully)

    I would create your date dimension with an integer key (clustered primary index) with the integer date value for that day. For example, today's key value would be 20160629....

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 29, 2016 at 8:54 am

    #1887653

  • RE: date Hierarchy (simple hopefully)

    Nope, just one will do! Each date dimension attribute becomes it's own hierarchy by default, but you can create custom hierarchies in the dimension designer. Just drag &...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 29, 2016 at 8:30 am

    #1887644

  • RE: Need to remove an arrow char at end of each file as well as a trailing comma in header

    I run into poorly formatted files on a fairly regularly when trying to consume external files via SSIS. My first choice is always to see if the source system...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 27, 2016 at 12:10 pm

    #1887109

  • RE: ssis

    Yes, use precedence constraints to handle the first part of your requirements. As far as the second part, whether or not your package has run this month, you'll have...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 24, 2016 at 2:12 pm

    #1886841

Viewing 15 posts - 16 through 30 (of 3,232 total)