Reputation: 6270
Is there any way to develop SSIS packages in SQL 2005 without using BIDS?
Upvotes: 0
Views: 361
Reputation: 89661
You can also create and save very basic import/export packages from SSMS. These can be loaded in BIDS for later modification.
Upvotes: 0
Reputation: 21505
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
Upvotes: 2