| Author |
Topic |
|
mikedavid00
Starting Member
8 Posts |
 Posted - 2007-10-31 : 11:40:47
|
| Hi!We have SQL 2005 x64 installed on a 64 bit server.We have 32 bit XP systems that we'd like to develop SSIS packages on and then deploy them to the 64 bit server to run in 64 bit mode. Is this possible?Note: We only have 64 bit SQL 2005 media right now.Thanks! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-31 : 11:45:01
|
| Yes.Can't remember what you have to do.You have to set an option when compiling script tasks (it tells you what to do) You might also get driver problems (that's a 64 bit issue though not ssis).Try it at the earliest opportunity - and test everything new that you attempt. Don't leave it until the last moment.It's a good idea to have a 64bit server that the developers can deploy to and test.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
mikedavid00
Starting Member
8 Posts |
Posted - 2007-10-31 : 11:50:34
|
| Hi nr, What about the media? How would I get the BI Studio on the 32 bit XP machines? Can I just download the 32 bit trial edition and I will be able to create a new SSIS package?Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-31 : 11:59:39
|
| You'd need to purchase the 32-bit version of developer edition, one license per developer.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
mikedavid00
Starting Member
8 Posts |
Posted - 2007-10-31 : 12:16:05
|
| Tkizer, please tell me it isn't so!We just bought SQL 2005 Enterprise x64 for our ESX. We can publish reports no sweat, but why is SSIS so different? Are you sure we need to purchase another SQL version all together? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-31 : 12:45:33
|
| You don't have the developer edition?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-31 : 13:11:42
|
quote:
Originally posted by mikedavid00
Tkizer, please tell me it isn't so!We just bought SQL 2005 Enterprise x64 for our ESX. We can publish reports no sweat, but why is SSIS so different? Are you sure we need to purchase another SQL version all together?
What you purchased is for the server and not for the client machines. Developer edition is only 50 bucks per license (per developer), so this really shouldn't set you back any.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
mikedavid00
Starting Member
8 Posts |
Posted - 2007-10-31 : 13:20:58
|
| No sir. We only have Standard Edition. We can indeed create SSIS packages via remote desktop, but would like to create them locally on 32 bit PC's. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-31 : 13:28:42
|
| And hence you'll need more licenses. You can not legally run the client tools on client machines without licenses.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
mikedavid00
Starting Member
8 Posts |
Posted - 2007-10-31 : 13:36:03
|
| So all we have to do is spend $50 a developer? Oh thank goodness. We're downloading the trial now.Deosn't that edition basically include Enterprise server along with it? Isn't that a whole other SQL server?How do we register for licenses? Why is it so cheap? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-31 : 13:44:14
|
| All of the information is available on the MS site. I can't explain why it's so cheap. You'd have to ask MS about that. But keep in mind that you can't run production on developer edition. It is purely for developing.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-31 : 13:45:31
|
| It includes the developer edition which is very like the enterprise edition but without the production license.>> Why is it so cheap?Because microsoft want people to learn the product so they will tell companies to use it and spend lots more money.A bit like giving away products to universities so that students will want to use them in companies afterwards.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-31 : 13:52:53
|
| If I remember right, a few years ago developer edition was $500 a copy and then it dropped to $50. I think this is because they want more people to use it or give it a try. Of course you can't run production on it, you can't use it if it is going to be connecting to the internet (or something like that) with the app, and there are other limitations built in I think (like a certain # of concurrent users). |
|
|
|
|
Very basic question regarding deployment to 64 bit