September 28, 2017 at 5:10 am
Hello
The package attached worked fine and all rows are inserted. what I am trying to do now is if a new data is added into the excel source and I run the package again only the new row is inserted into my excel destination. Thanks for your help
September 28, 2017 at 6:40 am
One way of doing this would be to read the key data from the Excel spreadsheet into a cache transform as step 1 of your package and then use the generated cache as the source for a Conditional Split which checks incoming rows against those in the cache and discards matches.
September 28, 2017 at 8:09 am
Phil Parkin - Thursday, September 28, 2017 6:40 AMOne way of doing this would be to read the key data from the Excel spreadsheet into a cache transform as step 1 of your package and then use the generated cache as the source for a Conditional Split which checks incoming rows against those in the cache and discards matches.
Thanks Phil for your reply I added the cache transform how can I specify the conditional Split.
September 28, 2017 at 8:38 am
ericmbiada - Thursday, September 28, 2017 8:09 AMPhil Parkin - Thursday, September 28, 2017 6:40 AMOne way of doing this would be to read the key data from the Excel spreadsheet into a cache transform as step 1 of your package and then use the generated cache as the source for a Conditional Split which checks incoming rows against those in the cache and discards matches.Thanks Phil for your reply I added the cache transform how can I specify the conditional Split.
Read this for some additional info.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy