August 19, 2015 at 12:12 pm
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:
My learning curve was about a month for the basic stuff. Another month for the more complicated crap (like expressions). Once I got past that, suddenly I knew what to Google, what to look up in BOL, and how to do pretty much everything but scripting.
August 19, 2015 at 12:13 pm
Jack Corbett (8/19/2015)
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.
That's where I'm at with my current job. Every time I try to learn a new skill, I have to stop in the middle, do work things, and then try to remember stuff. And then when I do learn it, I lose it all because I can't practice it. Most of the stuff I need to learn, we don't use. @=(
August 19, 2015 at 4:03 pm
Silver spoon, silver spoon, silver spoon, when are you going to admit you are in over your head and really need to find a different career.
August 19, 2015 at 4:35 pm
And then there are those Oracle people seeking help on a MS SQL Server forum and seem surprised that a T-SQL solution won't work on an Oracle server.
August 20, 2015 at 2:26 am
Lynn,
Remind me when we meet at Summit to buy you at least 2 of your favorite beverages! It's not really enough to pay you back for your patience on SSC, but it's start 🙂
But I'm not buying any for the Hippo, ok? :w00t:
Rodders...
August 20, 2015 at 2:38 am
Grant Fritchey (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:Get started with BIML now. You'll be happier in the long run.
Only if you have to create a lot of repetitive packages.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 20, 2015 at 2:41 am
Sean Lange (8/19/2015)
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:
Is kinda stupid indeed for varchar to nvarchar, but to other way around is certainly not.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 20, 2015 at 3:32 am
My first article ever has gone live . Hope you guys enjoy.
August 20, 2015 at 3:43 am
BL0B_EATER (8/20/2015)
My first article ever has gone live . Hope you guys enjoy.
Link?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 20, 2015 at 3:48 am
Koen Verbeeck (8/20/2015)
BL0B_EATER (8/20/2015)
My first article ever has gone live . Hope you guys enjoy.Link?
Sorry - http://www.sqlservercentral.com/articles/SQL+Server/127992/"> http://www.sqlservercentral.com/articles/SQL+Server/127992/
I am no BI expert just needed to do a solution for £0.
🙂
August 20, 2015 at 7:02 am
Koen Verbeeck (8/20/2015)
Sean Lange (8/19/2015)
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:Is kinda stupid indeed for varchar to nvarchar, but to other way around is certainly not.
Agreed 100% that the other way should be an issue but seriously...the best part was I spent the better part of an hour trying to figure out how I was going to deal with a datetime to date conversion because the source is 2005 and as such can't cast as date. Only to find out that in that case it will do implicit conversion. GAH!!!
_______________________________________________________________
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 20, 2015 at 7:21 am
Sean Lange (8/20/2015)
Agreed 100% that the other way should be an issue but seriously...the best part was I spent the better part of an hour trying to figure out how I was going to deal with a datetime to date conversion because the source is 2005 and as such can't cast as date. Only to find out that in that case it will do implicit conversion. GAH!!!
Now that part is kinda funny. Not that you spent an hour on it, but that it'll do an implicit cast sometimes but not all the time.
Granted, I don't know much about SSIS other than how to spell it...and sometimes I get that part wrong. 😛
Personally, I do my ETL using T-SQL. I know that doesn't help me learn anything new, but it's fast, reliable and straightforward. There's also the issue of familiarity. Gee...I hope I'm not becoming old and stodgy. 😉
August 20, 2015 at 7:33 am
Ed Wagner (8/20/2015)
Sean Lange (8/20/2015)
Agreed 100% that the other way should be an issue but seriously...the best part was I spent the better part of an hour trying to figure out how I was going to deal with a datetime to date conversion because the source is 2005 and as such can't cast as date. Only to find out that in that case it will do implicit conversion. GAH!!!Now that part is kinda funny. Not that you spent an hour on it, but that it'll do an implicit cast sometimes but not all the time.
Granted, I don't know much about SSIS other than how to spell it...and sometimes I get that part wrong. 😛
Personally, I do my ETL using T-SQL. I know that doesn't help me learn anything new, but it's fast, reliable and straightforward. There's also the issue of familiarity. Gee...I hope I'm not becoming old and stodgy. 😉
I typically do it using t-sql myself but in this case SSIS just makes sense because the data is coming from so many places. As SSIS packages go this is one is super simple. I am grateful for the chance to learn some stuff if only because I have much more knowledge about what the people who do this all the time (i.e. Koen) have to work with on a routine basis. The flexibility offered is a LONG way from DTS and it is all more intuitive.
_______________________________________________________________
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 20, 2015 at 7:36 am
Ed Wagner (8/20/2015)
Now that part is kinda funny. Not that you spent an hour on it, but that it'll do an implicit cast sometimes but not all the time.
Granted, I don't know much about SSIS other than how to spell it...and sometimes I get that part wrong. 😛
Personally, I do my ETL using T-SQL. I know that doesn't help me learn anything new, but it's fast, reliable and straightforward. There's also the issue of familiarity. Gee...I hope I'm not becoming old and stodgy. 😉
I think you might be on the road to "old and stodgy" 😛
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 20, 2015 at 7:42 am
Sean Lange (8/20/2015)
I typically do it using t-sql myself but in this case SSIS just makes sense because the data is coming from so many places. As SSIS packages go this is one is super simple. I am grateful for the chance to learn some stuff if only because I have much more knowledge about what the people who do this all the time (i.e. Koen) have to work with on a routine basis. The flexibility offered is a LONG way from DTS and it is all more intuitive.
I agree with pretty much all you have to say here. If I can use T-SQL to do the task I use it because I can usually develop it faster and, often times, it will run faster because I take advantage of set-based processing, but when you have multiple sources of data and/or multiple stages your data needs to pass through I find SSIS is a better solution, even if it is just being used as a controller.
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
Viewing 15 posts - 50,281 through 50,295 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply