November 21, 2016 at 4:09 pm
Hello,
I am sending data(text file) to third party which they import to their tool which users pull information from and make changes.
That data sent is combination of multiple tables.
Then the third party sends out file to us with updated value, how do I update data from the text file
because it pulling information from more than one table.
November 21, 2016 at 4:15 pm
PJ_SQL (11/21/2016)
Hello,I am sending data(text file) to third party which they import to their tool which users pull information from and make changes.
That data sent is combination of multiple tables.
Then the third party sends out file to us with updated value, how do I update data from the text file
because it pulling information from more than one table.
Are you saying that the data file you receive needs to be used to update multiple tables in your database?
One of the simpler ways of doing this is to import the data into a staging table and then call a stored proc to handle all of the updating for you.
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
November 21, 2016 at 4:19 pm
Yes it would need to update multiple files in the table.
Are you implying that I import the file received from third party to a table and then update each table ?
November 21, 2016 at 4:26 pm
PJ_SQL (11/21/2016)
Yes it would need to update multiple files in the table.Are you implying that I import the file received from third party to a table and then update each table ?
Tables do not have files - what do you mean?
Yes, that's what I was implying.
It's not the only way, but it's the way I would do it. Keep the DB logic in the DB and use SSIS to move data around.
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply