Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hello, I am new to SSIS and I woul

Status
Not open for further replies.
May 25, 2020
1
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top