denisetic01
MIS
Hello,
I am new to SSIS and I would need your help! also, please forgive me if this question is a duplicated post.
SO here is my scenario: We are receiving a monthly feed in cSV format with about 9K of rows; what I need to do is to append all those data in a SQL relational table.
aside from that I need to re-populate the same set of data on the same table but I have to populate them in a daily; meaning from day 1 to day 30 - 31 depending on the current month.
So lets say I got this month's feed with 9k data; I need to process and append the same set of data from May 1 to May 31. It will be a duplicated records each day and what makes them distinct is the as of date.
Any idea how I can do that in SSIS?
Thank you so much in advance!
Denise
I am new to SSIS and I would need your help! also, please forgive me if this question is a duplicated post.
SO here is my scenario: We are receiving a monthly feed in cSV format with about 9K of rows; what I need to do is to append all those data in a SQL relational table.
aside from that I need to re-populate the same set of data on the same table but I have to populate them in a daily; meaning from day 1 to day 30 - 31 depending on the current month.
So lets say I got this month's feed with 9k data; I need to process and append the same set of data from May 1 to May 31. It will be a duplicated records each day and what makes them distinct is the as of date.
Any idea how I can do that in SSIS?
Thank you so much in advance!
Denise