March 3, 2010 at 11:44 am
Hello,
I am new to SSIS and am trying to create a pipe delimited file from multiple tables. Some of these tables have a one to many relationship and need to be exported line by line. Each line contains a set of data an example would be as such:
A
A1
A1
B
B1
B1
B1
D
D
E
E
E
E
E
Each letter represents a separate record set and its corresponding records that pertain to the file.
I know how to create the text file and export the tables and even how to export multiple tables to one file but I have no idea how to export them in the correct order and based on the correct business rules (which records belong with the other records based on the caseNumber).
Any help with this would be great.
Thanks,
George
March 3, 2010 at 11:49 am
Can you clarify what you mean by 'correct order'?
If possible, some sample data would probably help ... just enough to illuminate your ordering problem.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
March 3, 2010 at 12:54 pm
Phil Parkin (3/3/2010)
Can you clarify what you mean by 'correct order'?If possible, some sample data would probably help ... just enough to illuminate your ordering problem.
The correct order is each table in the sequence from lines A to C. A is the primary information which in this case has to do with account information. A1 lines have to do with property related liens. B lines are Interested Party information and any other B lines have to do with things that relate to the Interested Parties and C lines are Judgments that are related to the file.
The output below is the result of a VB/SQL application I wrote but we would like to automate this .. also it is painfully slow as it uses multiple loops and ADO Recordsets. The client wants the data exported to them in this output as they claim it is the easiest way.
Note that the data from each line comes from a DIFFERENT table.
An example output file is as follows:
A|09-0403|062195300|ALL THAT CERTAIN lot or piece of ground with the buildings and improvements thereon erected, lot or piece of ground with the buildings and improvements thereon erected, described according to a sruvey thereof made by Joseph Johnson, Esq., Surveyor and Regulator of the 11th District as follows, to wit:
SITUATE on the Northeasterly sside of Lediy Avenue at the distance of 310 feet 2-5/8 inches Northwestwardly from the point of intersection of the said Northeastwardly side of Leidy Avenue with the North side of Girard Avenue.
CONTAINING in front or breadth on the said Leidy Avenue 17 feet and extending of that breadth in length or depth Northeastwardly between lines at right angles to the said Leidy Avenue, 160 feet to Viola Street.
BEING the same premises which Robert H. Mitchell and O'Kella E. Mitchell, h/w by Indenture bearing the date 10/21/1974 and recorded 02/14/1975 at Philadelphia, PA in Deed Book DCC 803 - 221, granted and conveyed to Christ Community Baptist Church, a PA Non-Profit Corporation.
Known By BRT as: 4131 LEIDY AVE
06-2-195300|03272009|Vacant land -- address not adequate for notice of foreclosure.
Possible City Transfer Tax due if Grantee was not granted exemption claimed in 1974 Deed.
Comm of PA to be notified of foreclosure for possible outstanding tax liability (corporate or fiduciary record owner).[1]098 N 01 - 059[2][3]-[4][5]310'2 5/8"" W GIRARD" 17'X160' KITCHEN 2 FAMILY 17'X160'[6]-[7]0[8]|
A1||00050002|375.77|03312000||
A1||02011152|372.80|12182001||
A1||03050708|640.09|04242003||
B|O|||||Christ Community Baptist Church, a PA Non-Profit Corporation|||||||1224 North 41st Street||Philadelphia|PA|19104||DCC 803 - 221|117|
B3|Deed|1800|10211974|02141975|DCC 803 - 221|Christ Community Baptist Church, a PA Non-Profit Corporation|51|
C|G|Robert H. Mitchell and O'Kella E. Mitchell, h/w|
C|RB|CHRIST COMMUNITY BAPTIST CHURCH|
C|TA||
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply