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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:12 AM
Points: 1,833, Visits: 731
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: Wednesday, April 16, 2014 1:39 PM
Points: 388, Visits: 1,034
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 01, 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 01, 2013 6:14 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:39 PM
Points: 388, Visits: 1,034
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 4:48 PM
Points: 402, Visits: 121
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 01, 2013 1:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:03 AM
Points: 13, Visits: 34
Hi Andy,
Really very nice introduction to begin SSIS.

Thanks
Post #1510511
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse