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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Leonard » What is SSIS? Step 1 of the Stairway to...

37 posts, Page 1 of 4

1 2 3 4 »»»

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

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Leonard

Posted Monday, February 14, 2011 10:37 AM

Old Hand

Group: General Forum Members
Last Login: Monday, June 10, 2013 12:27 PM
Points: 375, Visits: 950

Comments posted to this topic are about the item What is SSIS? Step 1 of the Stairway to Integration Services

Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard

Post #1063676

jberg-604007

Posted Thursday, February 17, 2011 11:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 11, 2013 11:27 AM
Points: 123, Visits: 291

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

Post #1065873

Koen Verbeeck

Posted Tuesday, March 29, 2011 11:59 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:30 AM
Points: 9,410, Visits: 6,495

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

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1085988

99zardoz

Posted Wednesday, March 30, 2011 3:24 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 9:41 AM
Points: 21, Visits: 29

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.

Post #1086059

kwoznica

Posted Wednesday, March 30, 2011 7:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 10, 2013 6:52 AM
Points: 135, Visits: 283

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.

Post #1086181

Read It

Posted Wednesday, March 30, 2011 9:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:07 PM
Points: 5, Visits: 96

jberg-604007 (2/17/2011)

I had the same initial thought. I thought. But my take was, FINISH THE SERIES NOW!!! w00t

Great article to start off the series.

Post #1086284

Elliott Whitlow

Posted Wednesday, March 30, 2011 9:50 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 5,863, Visits: 4,886

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

CEWII

Post #1086308

vsolomon

Posted Wednesday, March 30, 2011 10:07 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 06, 2013 8:58 AM
Points: 220, Visits: 64

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.

Post #1086321

Dave-739983

Posted Wednesday, March 30, 2011 4:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 8:18 PM
Points: 6, Visits: 142

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

Post #1086561

Meet George Jetson

Posted Wednesday, March 30, 2011 4:17 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 1,293, Visits: 1,217

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.

Post #1086563

« Prev Topic | Next Topic »

37 posts, Page 1 of 4

1 2 3 4 »»»

Permissions