Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
whizsql
Starting Member
17 Posts |
 Posted - 2008-12-15 : 10:47:18
|
| I just created my first SSIS import export package, which exports data from a number of tables from database A to B.I did execute the package & looked good. I want to add a few more tables to the package to export..how do I edit the package to do that?Thanks for help in advance ! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 11:20:51
|
| open the package in sql business intelligence development studio(BIDS) and add new tables (OLEDB source & destinations) inside data flow task.you can find BIDS under start->programs->microsoft sql server 2005 provided you've installed the client tool. |
 |
|
|
|
|
|
Edit SSIS import Export package