November 27, 2009 at 2:10 am
Hi,
I have to create a package which will handle Delta as well as Full Load.
Please let me know if anybody has implemented the same.
vishal
November 27, 2009 at 1:03 pm
Implemented based on Primary key in the tables And / Or based on datetime Columns that are used to track the data that needs to be moved.
It's a general question and you need to give specifics about your data upon which it would be easy to suggest.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 30, 2009 at 2:51 am
Hi,
Could you please elaborate more because i am new to SSIS and same i have to implement in SSIS 2005.
Vishal
November 30, 2009 at 3:20 am
The elaboration is that you need to provide a few more details about your data before anyone can help you in any detail. By 'delta', I'm guessing that you mean loading only data changes? Does that mean inserts only, or inserts and updates, or inserts, updates and deletes?
Do your data records have a 'date last modified' column?
How many columns are in the data you are uploading?
What is the PK of the data and does the PK exist in the data which you are loading as well as the target data?
I appreciate that you are new to SSIS and that there is a lot to learn, but no one here is going to develop your package for you - you need to at least learn the basics and have an idea of what you are trying to achieve, then we can help you with all those niggling questions that come up as you work through it all.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
December 2, 2009 at 1:01 am
Hi,
Here are the details:
I need to add a parameter to the SSIS package that identifies FULL vs. DELTA, i.e., PROCESSTYPE = FULL or DELTA.
For the original Vurv process, the SSIS package will be kicked off passing the FULL parameter value.
For the new Taleo feed files, the SSIS package will be kicked off passing the DELTA parameter value.
And i dont have date column in my source table, i have primary key.
vishal
January 15, 2018 at 3:27 am
vishal.kunwar - Wednesday, December 2, 2009 1:01 AMHi,Here are the details:I need to add a parameter to the SSIS package that identifies FULL vs. DELTA, i.e., PROCESSTYPE = FULL or DELTA. For the original Vurv process, the SSIS package will be kicked off passing the FULL parameter value. For the new Taleo feed files, the SSIS package will be kicked off passing the DELTA parameter value.And i dont have date column in my source table, i have primary key.vishal
I know this is very old post, but the reply may help someone.
You can use a package variable and assign the value to it from config file. Package will first read this variable and on the basis of it's value, it will process.
January 15, 2018 at 5:27 am
dssingh17-819020 - Monday, January 15, 2018 3:27 AMvishal.kunwar - Wednesday, December 2, 2009 1:01 AMHi,Here are the details:I need to add a parameter to the SSIS package that identifies FULL vs. DELTA, i.e., PROCESSTYPE = FULL or DELTA. For the original Vurv process, the SSIS package will be kicked off passing the FULL parameter value. For the new Taleo feed files, the SSIS package will be kicked off passing the DELTA parameter value.And i dont have date column in my source table, i have primary key.vishalI know this is very old post, but the reply may help someone.
You can use a package variable and assign the value to it from config file. Package will first read this variable and on the basis of it's value, it will process.
After nine years, one would hope that the OP solved their problem, one way or another!
But I believe the original question was a general one, asking how to load changes and how to do a full load, based on the value of a package variable.
I previously stopped posting to the thread because the OP did not provide the answers to the questions I asked ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply