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 |
|
alienrock24
Starting Member
2 Posts |
 Posted - 2010-06-07 : 11:37:55
|
| Hi All,I need to create SSIS package for following scenario Case1: when a row is updating, before updating it has to delete that row and it must be saved in flat file case2: now after deleting the changed row, now it has to insert the new row which has been updated and it is also saved in flat file.Help me Please.Thank you.Alienrock24 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-06-07 : 11:54:18
|
| Essentially you want the row before and after the update.Maybe there's a better way....but you could do this.1.Data Flow Task - Do a SELECT with a SQL Server Data Source and Flat File Destination.2. Execute SQL Task - Do the Update here.3. Data Flow Task - Same as 1. - Do a SELECT with a SQL Server Data Source and Flat File Destination - use same flat file connection manager and select append data checkbox. |
 |
|
|
alienrock24
Starting Member
2 Posts |
Posted - 2010-06-08 : 08:24:00
|
| Hi Vijay,Thanks for responding to my posting. I'm working on it, as what u said ?But I forgot to mention there i need to capture date and time of the deleting and inserting records and keep them in a separate flat file again.Please help me.thank you.Alienrock24 |
|
|
|
|
|
|
SSIS p'age to g'rate flatfile 4 delete and insert