Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

What is SSIS? Step 1 of the Stairway to Integration Services Expand / Collapse
Author
Message
Posted Monday, February 14, 2011 10:37 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:15 PM
Points: 388, Visits: 1,044
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
Posted Thursday, February 17, 2011 11:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 23, 2013 1:01 PM
Points: 123, Visits: 293
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
Posted Tuesday, March 29, 2011 11:59 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:00 AM
Points: 13,524, Visits: 11,313
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
Posted Wednesday, March 30, 2011 3:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 10, 2014 8:39 AM
Points: 23, Visits: 39
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
Posted Wednesday, March 30, 2011 7:00 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 25, 2014 8:35 PM
Points: 187, Visits: 434
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
Posted Wednesday, March 30, 2011 9:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 24, 2013 10:36 AM
Points: 5, Visits: 97
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!!! Great article to start off the series.
Post #1086284
Posted Wednesday, March 30, 2011 9:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
Good article Andy, I look forward to reading the rest of the series..

CEWII
Post #1086308
Posted Wednesday, March 30, 2011 10:07 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 6, 2014 8:30 AM
Points: 307, Visits: 78
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
Posted Wednesday, March 30, 2011 4:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 7:01 PM
Points: 9, Visits: 178
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
Posted Wednesday, March 30, 2011 4:17 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, November 15, 2014 10:17 PM
Points: 1,835, Visits: 1,333
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 »

Add to briefcase 1234»»»

Permissions Expand / Collapse