September 30, 2011 at 10:12 am
I got to design a package whihc will pull some recordsfrom source to destination. The scenario here is
Table A
name----id----date
A-------1-----09/27/2011
A1------2-----09/27/2011
A2------3-----09/28/2011
B-------4-----09/28/2011
B1------5-----09/28/2011
Here A1 and A2 are the dependents of A
B1 dependent of B
Now here i a get new record today for example
A3----6----09/30/2011 into Table A
now i need to design an SSIS package whihc will pull the newly entered record and all the group records too..
Like i got to pull A, A1, A2 records also with the A3 record(as A3 belongs to A group and remaining A1 and A2 too) into the destination table
So when package is run we will have results like
A-------1-----09/27/2011
A1------2-----09/27/2011
A2------3-----09/28/2011
A3------6-----09/30/2011
For this i'm using conditional split by date where i get newly added records from the previous date. But here i'm able to get only that newly added record but not the group one.
So cansome one help me out with this please
September 30, 2011 at 1:45 pm
tripri (9/30/2011)
I got to design a package whihc will pull some recordsfrom source to destination. The scenario here isTable A
name----id----date
A-------1-----09/27/2011
A1------2-----09/27/2011
A2------3-----09/28/2011
B-------4-----09/28/2011
B1------5-----09/28/2011
Here A1 and A2 are the dependents of A
B1 dependent of B
Now here i a get new record today for example
A3----6----09/30/2011 into Table A
now i need to design an SSIS package whihc will pull the newly entered record and all the group records too..
Like i got to pull A, A1, A2 records also with the A3 record(as A3 belongs to A group and remaining A1 and A2 too) into the destination table
So when package is run we will have results like
A-------1-----09/27/2011
A1------2-----09/27/2011
A2------3-----09/28/2011
A3------6-----09/30/2011
For this i'm using conditional split by date where i get newly added records from the previous date. But here i'm able to get only that newly added record but not the group one.
So cansome one help me out with this please
It's hard to know where to start... your table design doesnt really make sense. If there is a logical grouping of records then there should be something "the same" about those records,.... so instead of names like A, A1 and A2. They should have firstname A, lastname 1... then you can select records based on that value "where firstname ='A'....
Now, assuming you know better and aboslutely refuse to consider looking at why your table is designed this way...
why could you jsut say WHERE NAME LIKE 'A%' to select all the records that start with A...
Maybe I am misunderstanding your question.... you could post some ddl and make things more clear.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply