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 |
|
parass
Starting Member
3 Posts |
 Posted - 2008-08-12 : 17:57:16
|
| Hi,I have a table that has a first column with sequential data. I need to create a ssis package that will run each hour and write the all the data from table in flat file. each hour there might be new row added to sql table, so next hour I should be appending the only newly added rows to the flat file. Please suggest how to create this package.Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-12 : 20:06:27
|
| You can use Export/Import package for it and schedule it. Next time your package runs it appends to destination xls file. |
 |
|
|
|
|
|
SSIS package design