September 3, 2009 at 2:59 am
Hi,
I'm Using SSIS for data transformation from flat file to Oracle . As of now I'm Using the entire SQL Server 2005 . Scence I need only SSIS part ,I have some Doubts in my mind .
Is it possible to install only SSIS Not whole SQL Server.
If So What about licencing Whether we need to purchasre the full licence or Only for SSIS?
Regards,
Guru
September 3, 2009 at 3:46 am
gurukiran.bhat (9/3/2009)
Hi,I'm Using SSIS for data transformation from flat file to Oracle . As of now I'm Using the entire SQL Server 2005 . Scence I need only SSIS part ,I have some Doubts in my mind .
Is it possible to install only SSIS Not whole SQL Server.
If So What about licencing Whether we need to purchasre the full licence or Only for SSIS?
Regards,
Guru
As far as I know, you can install SSIS separately, but you will still need to have a license. if you want to cut costs, get a developer edition and just install SSIS as long as you are not using it in production.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 3, 2009 at 3:49 am
That means, If I have to run SSIS in production , I cant purchase only SSIS, i have to purchase Entire SQL Server 2005
September 3, 2009 at 4:12 am
gurukiran.bhat (9/3/2009)
That means, If I have to run SSIS in production , I cant purchase only SSIS, i have to purchase Entire SQL Server 2005
Yes, SSIS is a sql component, you would need to have a license for SQL Server 2005, even if you only use SSIS.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 3, 2009 at 8:10 am
You can load flat files into Oracle without using SSIS. I am pretty sure you can use PL\SQL to load data in. I have used PL\SQL to get data out. One warehouse I worked on used OWB (not as nice as SSIS). Another we used C with embedded SQL. Another I am sure we used some sort of Oracle bulk copy.
If you are only ever going to use SSIS for just a handfull of files it could be a lot of money. However if you utilise some of the other components then maybe not.
Ells.
😎
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply