Posted by: stylish August 12, 2008
List all the SQL Server interview questions
Login in to Rate this Post:     0       ?        

Grunge83 I have a question, Please help me hai..

I have a table with suppose 50 rows. I am designing a SSIS package to copy the data from the OLEDB data source to a flat file connection and i running this package as a job on a scheduled basis..

Now, suppose this package is run every 1 hour.

So, my question is how to design that package such dat at the next hour ( ie 2) only the new inserted rows on the table is appended to that flat file.

Thanx

 

 

Read Full Discussion Thread for this article