What is SSIS? Step 1 of the Stairway to Integration Services

Question

What is SSIS? Step 1 of the Stairway to Integration Services

Andy Leonard

SSChampion

Points: 10144
More actions
February 14, 2011 at 10:37 am

#231823

Comments posted to this topic are about the item What is SSIS? Step 1 of the Stairway to Integration Services
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

Viewing 15 posts - 1 through 15 (of 41 total)

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

maroon-78 Ten Centuries Points: 1014 More actions · Answer 1

Hi Andy,

Any chance that you can move your articles out of the future and into the present? The first article has a posting date of 2011/03/30 and this is only 2011/02/18. Thanks for articles and allowing us to go back to the future to read them!

Jim

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Nice introductory article, Andy! Can't wait for the rest of the series.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

99zardoz Say Hey Kid Points: 661 More actions · Answer 3

Thanks for the article - I look forward to the next ones.

I try and use SSIS for any new ETL functionality we need, but as for having the time to migrate our hundreds of old DTS packages, forget it. Whatever Microsoft want, DTS will still linger on for a few years yet it many organisations I think.

kwoznica SSCertifiable Points: 5275 More actions · Answer 4

Andy,

Great article and I am looking forward to the rest of the series. I am just starting to learn SSIS as my company is looking for faster ways to view data. I am hoping to run SSIS packages which reads data and dumps it into an excel file which can be viewed by managers.

We are finding reports from our ERP to be very slow and the time it takes to run queries which produce the same data is 10 times faster.

I just have a couple of questions for you. You mention C# as a scripting tool in conjunction with SSIS. How important is it to know C# for SSIS and what shortcomings do you face without it?

Is it difficult to take queries I have successfully run and transport them into an ssis package to be run as a job?

Thanks for the article and your reply.

Read It SSC Enthusiast Points: 135 More actions · Answer 5

jberg-604007 (2/17/2011)
Hi Andy,
Any chance that you can move your articles out of the future and into the present? The first article has a posting date of 2011/03/30 and this is only 2011/02/18. Thanks for articles and allowing us to go back to the future to read them!
Jim

I had the same initial thought. I thought. But my take was, FINISH THE SERIES NOW!!! :w00t: Great article to start off the series.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 6

Good article Andy, I look forward to reading the rest of the series..

CEWII

vsolomon SSC-Addicted Points: 412 More actions · Answer 7

Thank you! I Look forward to Step2 and beyond. I work at a place that provides very little technical training, so this type of article is invaluable.

Dave-739983 SSChasing Mays Points: 645 More actions · Answer 8

Love your work Andy... look forward to reading the subsiquent articles.

Does anyone know if anything similar has been done for Analysis Services... "now there is one puppy I have trouble understanding."

Dave

Meet George Jetson SSChampion Points: 11626 More actions · Answer 9

Thanks Andy, I am looking forward to the next step in the series.

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.

ghanshyam.kundu Hall of Fame Points: 3337 More actions · Answer 10

Andy,

Great article i am dying know more about SSIS, looking forward to read the rest of the series.

thanks buddy great work

ghanshyam.kundu Hall of Fame Points: 3337 More actions · Answer 11

Hi Andy,

Great article I am dying to know more about SSIS, looking forward to read the rest of the series.

thanks buddy great work

Joachim Seminck Grasshopper Points: 20 More actions · Answer 12

Good stuff. Looking forward to the rest of the articles to improve my SSIS knowledge.

Anipaul SSC-Insane Points: 24681 More actions · Answer 13

Andy

This is great stuff... Eager to read the rest....

Andy Leonard SSChampion Points: 10144 More actions · Answer 14

kwoznica (3/30/2011)
You mention C# as a scripting tool in conjunction with SSIS. How important is it to know C# for SSIS and what shortcomings do you face without it?
Is it difficult to take queries I have successfully run and transport them into an ssis package to be run as a job.

Hi kwoznica,

You have the choice of C# or VB for scripting in SSIS 2008 and 2008 R2. It's not mandatory to know how to script to write SSIS packages, but knowing scripting adds another tool to your toolbelt for building SSIS (and other) solutions. I recommend you learn as much as you can.

You can use the Execute SQL Task to run queries in SSIS. Most developers mature as they work with a language or platform - their coding style evolves. Many SSIS developers start learning SSIS by building packages using the Import and Export Data Wizard. This wizard actually creates an SSIS package in RAM and then executes it. You can save the package and open it for editing or re-execute it later.

Other SSIS developers begin by using only Execute SQL Tasks for T-SQL operations. They use the SSIS Control Flow as a "workflow engine" (it's an excellent workflow engine!) and learn the Data Flow later.

:{> Andy

Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics