February 3, 2005 at 6:46 am
is there a way to create a dts, with active x script, to get data from a flat file, that will update and insert records into a sql server table,
in order words, get the record from a comma delimited file, check it against the data in the table. if the data exits,update with new incoming record (except for key fields), else just insert the record.
[font="Comic Sans MS"][/font]It is what it is.
February 3, 2005 at 6:56 am
Look at the Data Drive Query Task component in DTS, this is the best item for that scenario.
February 3, 2005 at 7:53 am
ave tried that but because the source is flat file and it is an update, when i am writing the sql statement, i dont know how to spcify the source in the query
[font="Comic Sans MS"][/font]It is what it is.
February 3, 2005 at 8:01 am
Gotcha, I will try to provide you the details when I get a chance.
February 3, 2005 at 10:51 am
actually ..no worries, i have a solution that works. i bring in the data from flat file to sql (staging Table)table, then do the updates and inserts using tsql.
thanks for pointing me in the right direction.
[font="Comic Sans MS"][/font]It is what it is.
February 3, 2005 at 10:51 am
actually ..no worries, i have a solution that works. i bring in the data from flat file to sql (staging Table)table, then do the updates and inserts using tsql.
thanks for pointing me in the right direction.
[font="Comic Sans MS"][/font]It is what it is.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply