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!
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.