Post reply

Are the posted questions getting worse?

  • August 18, 2015 at 5:01 pm

    #1820917

    Steve Jones - SSC Editor (8/18/2015)

    Well I fly to Louisville Thur, so I'm just hoping my updateFlightSystemaphobia is just a phobia this week.

    Take a computer with bad software on it with you. Rumor has it that having two sets of bad software on the same plane are from slip to none. 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 19, 2015 at 8:44 am

    #1821080

    I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT different. It is just painful trying to do the "hello world" level stuff and feeling it was the first time I opened up sql server all over again. Sheesh talk about being humbled. :w00t:

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • August 19, 2015 at 8:55 am

    #1821084

    Sean Lange (8/19/2015)

    I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT different. It is just painful trying to do the "hello world" level stuff and feeling it was the first time I opened up sql server all over again. Sheesh talk about being humbled. :w00t:

    Good luck with that. It's a whole new world. It's not as bad as it looks at first glance, but it takes time to get started.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • August 19, 2015 at 8:57 am

    #1821086

    Sean Lange (8/19/2015)

    I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT different. It is just painful trying to do the "hello world" level stuff and feeling it was the first time I opened up sql server all over again. Sheesh talk about being humbled. :w00t:

    I think SSIS is better that DTS. Of course I haven't worked with SSIS since I left School District 11. There is a lot of power in SSIS compared to DTS and you can do a lot of dynamic work easily in SSIS once you get over the learning curve.

  • August 19, 2015 at 9:03 am

    #1821092

    Luis Cazares (8/19/2015)

    Sean Lange (8/19/2015)

    I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT different. It is just painful trying to do the "hello world" level stuff and feeling it was the first time I opened up sql server all over again. Sheesh talk about being humbled. :w00t:

    Good luck with that. It's a whole new world. It's not as bad as it looks at first glance, but it takes time to get started.

    Thanks. Shouldn't be too bad. This is a super simple process. No need for the "T" portion. Just need to truncate a staging table and pull data from a procedure on three remote servers into a single location. It is simple stuff, executing a procedure and putting the result set in a table.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • August 19, 2015 at 9:13 am

    #1821095

    Sean Lange (8/19/2015)

    Luis Cazares (8/19/2015)

    Sean Lange (8/19/2015)

    I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT different. It is just painful trying to do the "hello world" level stuff and feeling it was the first time I opened up sql server all over again. Sheesh talk about being humbled. :w00t:

    Good luck with that. It's a whole new world. It's not as bad as it looks at first glance, but it takes time to get started.

    Thanks. Shouldn't be too bad. This is a super simple process. No need for the "T" portion. Just need to truncate a staging table and pull data from a procedure on three remote servers into a single location. It is simple stuff, executing a procedure and putting the result set in a table.

    Sounds like a good way to get your feet wet with the technology. That's one of the things I've like most about my career, I haven't been "just" a DBA or developer, I've touched the DB Engine, SSIS, and SSRS at intermediate to advanced levels, so I don't get bored. The downside is that the depth of knowledge in each area has been sacrificed for breadth of knowledge.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • August 19, 2015 at 9:13 am

    #1821096

    Sean Lange (8/19/2015)

    Thanks. Shouldn't be too bad. This is a super simple process. No need for the "T" portion. Just need to truncate a staging table and pull data from a procedure on three remote servers into a single location. It is simple stuff, executing a procedure and putting the result set in a table.

    One thing I learned quickly was that DTS allowed implicit conversions, SSIS does not 😉

    Far away is close at hand in the images of elsewhere.
    Anon.

  • August 19, 2015 at 9:22 am

    #1821102

    David Burrows (8/19/2015)

    Sean Lange (8/19/2015)

    Thanks. Shouldn't be too bad. This is a super simple process. No need for the "T" portion. Just need to truncate a staging table and pull data from a procedure on three remote servers into a single location. It is simple stuff, executing a procedure and putting the result set in a table.

    One thing I learned quickly was that DTS allowed implicit conversions, SSIS does not 😉

    Haha - one of the things that still gets me every now and again. Had to explain it to a junior colleague. I think he eyes glazed over!

    Rodders...

  • August 19, 2015 at 9:44 am

    #1821107

    Sean Lange (8/19/2015)

    I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT different. It is just painful trying to do the "hello world" level stuff and feeling it was the first time I opened up sql server all over again. Sheesh talk about being humbled. :w00t:

    Get started with BIML now. You'll be happier in the long run.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • August 19, 2015 at 9:54 am

    #1821110

    Jeff Moden (8/18/2015)

    Steve Jones - SSC Editor (8/18/2015)

    Well I fly to Louisville Thur, so I'm just hoping my updateFlightSystemaphobia is just a phobia this week.

    Take a computer with bad software on it with you. Rumor has it that having two sets of bad software on the same plane are from slip to none. 😛

    :w00t:

  • August 19, 2015 at 10:02 am

    #1821111

    Sean Lange (8/19/2015)

    I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT different. It is just painful trying to do the "hello world" level stuff and feeling it was the first time I opened up sql server all over again. Sheesh talk about being humbled. :w00t:

    Ha - I think the same thing every time I go back to DTS. What a painful nightmare DTS was. And then to have to figure it out for those once in a blue moon things - sheesh.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 19, 2015 at 10:08 am

    #1821113

    Sean Lange (8/19/2015)

    I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT different. It is just painful trying to do the "hello world" level stuff and feeling it was the first time I opened up sql server all over again. Sheesh talk about being humbled. :w00t:

    Remember that there is no magic there, everything works for a reason. Don't be shy opening the packages in a text editor, study the XML and learn from it.

    😎

  • August 19, 2015 at 10:46 am

    #1821125

    David Burrows (8/19/2015)

    Sean Lange (8/19/2015)

    Thanks. Shouldn't be too bad. This is a super simple process. No need for the "T" portion. Just need to truncate a staging table and pull data from a procedure on three remote servers into a single location. It is simple stuff, executing a procedure and putting the result set in a table.

    One thing I learned quickly was that DTS allowed implicit conversions, SSIS does not 😉

    Ha Ha!!! I was just beating my head against the wall when inserting varchar data into an nvarchar column and struggling with why it was not working. That is really kind of stupid imho. In my case I have data from 3 different systems being stuck into a single table and the source is nvarchar in some and varchar in others. Seems rather silly that I have to go back to my procedure and cast varchar to nvarchar for this to work. :w00t:

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • August 19, 2015 at 10:51 am

    #1821128

    Or you could do it directly in SSIS

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • August 19, 2015 at 10:57 am

    #1821130

    Sean Lange (8/19/2015)

    David Burrows (8/19/2015)

    Sean Lange (8/19/2015)

    Thanks. Shouldn't be too bad. This is a super simple process. No need for the "T" portion. Just need to truncate a staging table and pull data from a procedure on three remote servers into a single location. It is simple stuff, executing a procedure and putting the result set in a table.

    One thing I learned quickly was that DTS allowed implicit conversions, SSIS does not 😉

    Ha Ha!!! I was just beating my head against the wall when inserting varchar data into an nvarchar column and struggling with why it was not working. That is really kind of stupid imho. In my case I have data from 3 different systems being stuck into a single table and the source is nvarchar in some and varchar in others. Seems rather silly that I have to go back to my procedure and cast varchar to nvarchar for this to work. :w00t:

    The Data Transformation component can sort this out for you in your package, should you choose.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 15 posts - 50,266 through 50,280 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply