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 Wednesday, March 30, 2011 11:42 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 4:17 AM
Points: 235, Visits: 435
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
Posted Wednesday, March 30, 2011 11:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 4:17 AM
Points: 235, Visits: 435
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
Posted Thursday, March 31, 2011 3:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, March 31, 2011 6:48 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:30 AM
Points: 5,344, Visits: 1,388
Andy

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



Post #1086797
Posted Sunday, April 3, 2011 1:03 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 6:49 PM
Points: 389, Visits: 1,042
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
Posted Sunday, April 3, 2011 1:06 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 6:49 PM
Points: 389, Visits: 1,042
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
Posted Friday, March 9, 2012 2:47 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 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
Posted Sunday, March 11, 2012 1:02 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 6:49 PM
Points: 389, Visits: 1,042
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
Posted Friday, October 12, 2012 12:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 7, 2013 8:10 AM
Points: 1, Visits: 12
Great Article! I feel this is the platform to learn more about SSIS.

Looking forward fot the series!!
Post #1371901
Posted Friday, October 12, 2012 7:52 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 10:38 AM
Points: 80, Visits: 723
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 »

Add to briefcase ««1234»»»

Permissions Expand / Collapse