Edit SSIS package

[Injun]

I have the SSIS package using the wizard on the Visual studio. It basically creates the table and import the data from another database.

How can I edit this package to do the following modifications?

1. I want it to skip the Create table part. I found a CREATE TABLE query and I just deleted it . Is that what I need to do?

2. I want it to delete the data in the destination table before insering the data . Where can I do this modification.

I have about 80-90 packages . If I can edit the existing packages to achieve what I need it will save me alot of time recreating it.

Thanks

 

[mrdenny]

If you have removed the code which creates the table, then yes it will no longer create the table.

In order to truncate the destination table before hand you have to add a SQL Command to the package and have than object when finished start the data pump task.

Within the SQL Command object have it truncate the table.

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

 

[MDXer]

You would be better served using an execute SQL task in the control flow that truncates your table then has a workflow constraint to the Dataflow which has the actual data import.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck