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, November 26, 2012 4:42 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:17 AM
Points: 2,445, Visits: 1,027
As a prod DBA I've been a bit snobby and dismissive of SSIS in the past (even preferring DTS!) but with some clients I've had no choice but to get right in there and debug failing SSIS packages, but I will conceed it's a good feeling when you get them working. Will be following this series closely, knowledge is power and all that.

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1388528
Posted Friday, March 29, 2013 5:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 6:33 AM
Points: 5, Visits: 29
Hey Andy,
I'm just coming into the world of SSIS and I'm fighting my corporate DBA's about it.

Can you answer a fundamental question? And I know this probably isn't a good place for this, but...

If I install SSIS on a server that doesn't have SQL Server on it, just SSMS, do I need a full SQL license just to use SSIS to convert some DTS packages? They will eventually run on SQL2008, but we're waiting on the new servers at this point.

Based on lots of postings, I don't believe so. And Microsoft literature seems to be contradictory on the matter.

Thanks
Greg

Post #1436875
Posted Friday, March 29, 2013 5:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 6:33 AM
Points: 5, Visits: 29
Hey Andy,
I'm just coming into the world of SSIS and I'm fighting my corporate DBA's about it.

Can you answer a fundamental question? And I know this probably isn't a good place for this, but...

If I install SSIS on a server that doesn't have SQL Server on it, just SSMS, do I need a full SQL license just to use SSIS to convert some DTS packages? They will eventually run on SQL2008, but we're waiting on the new servers at this point.

Based on lots of postings, I don't believe so. And Microsoft literature seems to be contradictory on the matter.

Thanks
Greg

Post #1436876
Posted Saturday, March 30, 2013 7:36 PM


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
Hi Greg,

You can develop SSIS using Business Intelligence Development Studio (for 2005, 2008, and 2008 R2) or SQL Server Development Tools (for 2012) on any server with the workstation tools installed. You cannot execute packages outside the development environment without a SQL Server relational engine license. For this reason, I refer to SSIS as "free" (in double-quotes).

Hope this helps,
Andy


Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #1437263
Posted Monday, April 1, 2013 5:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 6:33 AM
Points: 5, Visits: 29
Hey Andy,
Thanks for the reply. That was how I read all of the Microsoft doc, but our "software police" seem to insist that a SQL license/install accompany BIDS or SSIS on any machine, which makes no sense to me.

I can attach to whatever servers I need to, develop the packages on SSMS on my workstation, and then install/store them on the actual server where they need to live, as I see it. And it sounds like that's what you're saying too.

OK, many thanks. This is all pretty new to me, compared to stored procedures. Just haven't had the need to get too heavily into it before.

Thanks again.
Greg
Post #1437398
Posted Monday, April 1, 2013 6:14 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
Hi Greg,

That is what I am saying, yes. You can develop SSIS packages on any machine just by installing the Microsoft Business Intelligence components. As far as I know, the same licensing applies to SSMS.

Hope this helps,
Andy


Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #1437411
Posted Monday, May 27, 2013 10:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, October 31, 2014 8:29 AM
Points: 519, Visits: 151
Very nice artifact, ooops, article!
Don't know if already mentioned, but due to considerations related to the space-time continuum, the former artist known as BIDS is now called Data Tools (under SQL Server 2012).

Cheers
Post #1457128
Posted Friday, November 1, 2013 1:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:21 AM
Points: 13, Visits: 43
Hi Andy,
Really very nice introduction to begin SSIS.

Thanks
Post #1510511
Posted Friday, July 4, 2014 1:16 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 13, 2014 9:23 PM
Points: 86, Visits: 223
very Useful for the Beginner, something like a spoon feeding Clear Explanation about "What is SSIS"..

Thanks,
Prabhu
Post #1589222
Posted Tuesday, September 2, 2014 12:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 12:44 PM
Points: 1, Visits: 1
Which version of the Adventureworks database is used for this stairway? I downloaded Adventureworks 2008R2 but the structure seems to be different.

Thanks,

Andrew
Post #1609749
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse