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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply