exclude table from DTS

[clientuser]

Is there a way to exclude a table from a current DTS package?

I have one table in my package that I dont want to be brought over, any suggestions?

 

[Stokleberry]

To modify and existing DTS package expand the Data Transformation Services folder in Enterprise Manager and click on "Local Packages". A list of DTS packages will appear. Double click on the one you wish to modify. Tables are specified in the Connection objects which can be modified or deleted from the package.

 

[clientuser]

Yes, I got that far, but I have 4 tabs: source, destination, tranformations, lookups and options..

It doesnt give me an option anywhere in any of those tabs to exclude a certain table?

 

[clientuser]

anyone have any suggestions?

 

[SQLSister]

Depends on how you are doing the transformations. If your source is SQL code, you should go in and modify the code on the source tab. If you are using a table view transformation, just look at all you rtransformations to find the one which specifies the transformation you no longer want to perform and delte the transformation object. (Highlight the line between the two connections and click the delete key.)