How to build SSIS package without SQL Server Standard Edition

Question

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!

Answer 1

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.

Answer 2

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.