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...

36 posts, Page 2 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

ghanshyam.kundu

Posted Wednesday, March 30, 2011 11:42 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, February 11, 2013 7:42 AM
Points: 212, Visits: 414

Andy,
Great article i am dying know more about SSIS, looking forward to read the rest of the series.
thanks buddy great work

Post #1086621

ghanshyam.kundu

Posted Wednesday, March 30, 2011 11:51 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, February 11, 2013 7:42 AM
Points: 212, Visits: 414

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

Post #1086622

Joachim Seminck

Posted Thursday, March 31, 2011 3:51 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 20, 2012 4:26 AM
Points: 8, Visits: 43

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

Post #1086727

Anipaul

Posted Thursday, March 31, 2011 6:48 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:35 AM
Points: 4,789, Visits: 1,336

Andy

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

Post #1086797

Andy Leonard

Posted Sunday, April 03, 2011 1:03 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:53 PM
Points: 375, Visits: 947

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
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard

Post #1087870

Andy Leonard

Posted Sunday, April 03, 2011 1:06 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:53 PM
Points: 375, Visits: 947

Dave-739983 (3/30/2011)

Does anyone know if anything similar has been done for Analysis Services...

Hi Dave,

Check out Bill Pearson's Stairway to MDX.

:{>

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

Post #1087871

SQL ORACLE

Posted Friday, March 09, 2012 2:47 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314

Andy:

In the level 1: you showed the screenshot where the controls under the Maintenance Plan Tasks are enabled.

Could you explain briefly how you did it? The controls in my system are all grayed out.
Many thanks in advance.

Post #1264634

Andy Leonard

Posted Sunday, March 11, 2012 1:02 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:53 PM
Points: 375, Visits: 947

Hi SQL Oracle,

In the Control Flow toolbox, there is a group labeled Maintenance Plan Tasks beneath the Control Flow Items group.

Hope this helps,
Andy

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

Post #1264905

sajjanmukesh_83

Posted Friday, October 12, 2012 12:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 5:16 AM
Points: 1, Visits: 7

Great Article! I feel this is the platform to learn more about SSIS.

Looking forward fot the series!!

Post #1371901

thisisfutile

Posted Friday, October 12, 2012 7:52 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:15 AM
Points: 56, Visits: 487

sajjanmukesh_83 (10/12/2012)

Great Article! I feel this is the platform to learn more about SSIS.

Looking forward fot the series!!

If you got here from an email today (and if you didn't notice that this article is being recycled...I didn't at first), you'll be happy to know that the rest of the series is already completed. You can find it here: http://www.sqlservercentral.com/stairway/72494/

I too am looking forward to reading them.

Hope this helps.

Post #1372139

« Prev Topic | Next Topic »

36 posts, Page 2 of 4

««1 2 3 4 »»»

Permissions