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 |
|
sachingovekar
Posting Yak Master
101 Posts |
 Posted - 2008-08-07 : 02:01:38
|
| In DTS1. i want to delete previous records from a sql server database.2. import new records into that table.3. run a procedure for datavalidation on that table.4. bring that output into one excel sheet.Can anyone please tell me how thats is possible.I have tried using two sql task. but doen't work out. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-07 : 02:49:34
|
quote:
Originally posted by sachingovekar
In DTS1. i want to delete previous records from a sql server database.2. import new records into that table.3. run a procedure for datavalidation on that table.4. bring that output into one excel sheet.Can anyone please tell me how thats is possible.I have tried using two sql task. but doen't work out.
You need1.Execute SQL task with DELETE/TRUNCATE statement2.Use Transform data task3.Execute SQL Task with EXEC SPName4.Transform data task with excel destination |
 |
|
|
|
|
|
delete then import and then execute task