Adding tables to an existing package

[joshuaguilty]

I have a DTS package which I would like to add new tables. Could anyone tell me where to insert them WITHOUT to redo the whole thing? Thank you.

 

[mrdenny]

All you should need to do is create the tables on the destination server and then traw transformations between the two connections.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[joshuaguilty]

I am sorry for being not clear. The thing I would like to do is to modify the package by adding more tables to transfer. Please help !

 

[mrdenny]

Which is exactly what I described doing, all be it with spelling errors.

First you have to create the tables on the destination server.
Then edit your DTS package and add transformations between the source and destination objects. There will be one new transformation per table that you wish to add.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[joshuaguilty]

Thank you. If you do not mind, could you lead me to that editing. I am totally new and need to do it.

 

[mrdenny]

Open the package and hold down the shift key and click on the two servers (Source first). Then right click and select new transformation. Select the table and create the same table on the destination.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[joshuaguilty]

Thank you again. Last question. Does this method allows a multiple adding of different tables ? Like in the original package there is only one table and I want to add two hundreds tables. Or there is other simple way to bulky add jobs !? Denny is the life saver.

 

[mrdenny]

If you want to edit a package the only way will be to do it by hand. An easier way to do this would be to use the import/export wizzard and have it create the package then save the package at the end of the wizzard. You can then edit any changes that you need to make.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[joshuaguilty]

Thank you for the advice.