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 |
|
PeeJay2583
Starting Member
40 Posts |
 Posted - 2011-05-13 : 07:07:08
|
| HiI have created a package using Import/export wizard which imports table from access to table in sql.If I run that pacakge it appends the data from access table to sql table and make the number of rows double whenever i run that package.Now what I was looking for is to create a package which first clear the sql table and then import the table from access.Any help would be appreciated. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-13 : 07:10:16
|
| Add an Execute SQL Task(s) that run DELETE or TRUNCATE TABLE statements on the affected tables before the Data Transformation tasks. |
 |
|
|
PeeJay2583
Starting Member
40 Posts |
Posted - 2011-05-13 : 07:16:21
|
| I found execute SQL Task in the SSIS toolbar but not Data transformation tasks, where do i get this from? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-13 : 07:23:13
|
| When you save the package and then open it in Business Intelligence Studio, there should be one or more Data Transformation Tasks that move data from Excel to SQL Server. You'll have to add the Execute SQL Task and then connect it to the first of those Data Transformations, so that it runs before all of them. |
|
|
|
PeeJay2583
Starting Member
40 Posts |
Posted - 2011-05-13 : 09:09:31
|
| It works great.Thanks robvolk! |
|
|
|
|
|
|
SSIS Package