tags:

views:

331

answers:

2
Q: 

How to build SSIS package without SQL Server Standard Edition

Hi,

I'm doing data migration between two SQL Server 2008 database using SSIS because I need to do some data transformation. I guess I need to use Business Intelligence Developement Studio which I have on my develop machine. But because I don't have SQL Server Standard Edition on my develop machine. The BIDS do not allow me to build the SSIS package. Is there any work around? Thanks a lot in advance!

+1  A: 

You would normally install SQL Server 2008 Developer Edition on your development box.

SQL Server 2008 Developer enables developers to build and test applications that run on SQL Server on 32-bit, ia64, and x64 platforms. SQL Server 2008 Developer includes all of the functionality of Enterprise Edition, but is licensed only for development, test, and demo use.

Mitch Wheat  2010-01-11 03:41:34
Thanks! But I think it also cost money. Is there any way to build the package with Express Edition? Or the present of the integration service on development environment is enssential for designing the package?
Roy  2010-01-11 04:33:32
Does your company have a MSDN subscription? Check, but I think you get a number of developer licences...
Mitch Wheat  2010-01-11 05:10:26
We have few subscriptions. But we decided not to use them unrestrictly. Thanks Wheat, I really appreciate your help!
Roy  2010-01-11 05:35:55
I guess what BIDS does is just use those assemblies come along with SSIS to generate the .dtsx file(which is actually xml). Am I right? If it is, I think maybe some 3rd party tool(best to be free) can do that job too.
Roy  2010-01-11 05:39:59
+1  A: 

When you installed BIDS, did you also install the client tools for SQL Server?

Alternatively, you could remote to the dev server and devlop the package directly on the server.

HLGEM  2010-01-11 18:52:29

related questions

In SQL Server 2008 how can I secure data in a way that it cannot be decrypted unless connected to a network?
Advantages of MS SQL Server 2008 over MS SQL Server 2005?
SqlDataReader.HasRows returns false since SQL 2008 upgrade
How do I set the login info for SQL Server 2008 in Entity Framework?
Move SSIS Packages from SQL Server 2005 to 2008.
Installation problem sql server 2008
How do I register a Web Reference for a SQL Server 2008 Reporting Service Report?
How to use DataMining feature of SQL Server 2008 with ASP.Net
SSAS Cube Browsing not working after SQL 2008 CTP uninstall
Hooking up Reporting Services 2005SP2 to SQL Server 2008
New Date/Time data types in SQL 2008
Can SQLExpress 2005 and 2008 be installed on same machine without issue?
Any reason to have SQL Server 2005 and 2008 installed on same machine?
Cloud Hosting options for ASP.NET 3.5 and SQL Server 2008
How do I get the full name of the current user from a SQL Reporting Services 2008 report?
How do I fix a Cross language installation problem in SQL Server 2008?
Upgrade MSDE to SQL Server 2008
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
SQL Server 2008 Reporting Services Report Definition Customization Extensions
Moving SQL2005 app to SQL2008
Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008
Can I use SQL Server Management Studio 2005 for 2008 DB?
SQL 2008 Dialect Support for NHibernate
SQL Server 2008 vs 2005 Linq integration
SQL Server 2005 and 2008 on same developer machine?