Is there any way to develop SSIS packages in SQL 2005 without using BIDS?
+2
A:
It is possible to create a package programmatically.
I'm not aware of any alternative graphical editors to BIDS.
To edit DTS packages, you need to install the DTS designer components
Ed Harper
2010-03-09 10:44:55
Thanks for help.
Pramodtech
2010-03-12 05:47:13
A:
You can also create and save very basic import/export packages from SSMS. These can be loaded in BIDS for later modification.
Cade Roux
2010-03-09 13:33:16