Todd McDermid -

Your solution is precisely what I wanted. I was able to use the File Properties Task and detect the file and used File System task with variables to...

OK. At least the big part of my problem of getting the parentId has been solved. I will include your recommendations while scripting the new inserts so as to get...

I am going to use this script for the first insert and then any new inserts will have an update statement for the ParentId.

In that case:

1. What would my update...

How would my insert statement look like if I need to insert a new record and relate to its parent 6 digit number

ABC00000000001 ABC Shipping Inc ...

This solution is perfect as it takes care of the ParentId.

So, when I write the insert statement, I would need to add the two columns Id+Idoffest as the values...

lmu92 (2/6/2010)

---

So, let me ask slightly different:

In the previous post we have

13 HRS001 ...

lmu92 (2/6/2010)

---

I'm almost there.

I just can't figure out why ID18 will point to ID17 instead of ID14, even if leafaccntnum=HRS0010001 shows up in row 14 the first time...

Would you please...

Well, I guess we are pretty much there with the solution. As lmu92's solution works good, and just needs to take care of...

The exact question is on this link http://qa.sqlservercentral.com/Forums/Topic859006-392-1.aspx

I provided sample data to help understand the output format needed for this..

Some more sample data

insert into dbo.companys(accountNumber,companyName,emailAddress,accountType,logo)

values ('HRS00100000000','HR Staffing Company','info@hrs.com','V','HRS'),

('HRS00100010000','HR Staffing North America','info@hrsna.com','V','HRS'),

('HRS00100010001','HR Staffing US','info@hrsus.com','V','HRS'),

...

For any given account, the parentId references the Id value of that accounts 6 digits number. This is just to create a Tree structure.

All 10 digit account numbers will have...

Should I then just include an update statement to get the parentId from the previously inserted Id value?

Also, this process needs to run every 30 mins, and a company record...

Yes, I figured why you asked me for the ParentId definition. Apparently, we had a lot of ambiguity in defining it.

Also, I had already conveyed my thoughts about dropping the...

Some more data as sample output to explain parentId

Id leafaccntnum companyname ...

I have edited the output to show the relationship between parentkeyId and id as below

Id leafaccntnum companyname ...