June 12, 2008 at 12:42 pm
Hi..I have 2 servers.....each server has 12 tables for each month, like tbljanuary, tblfebraury etc.. now my task is to get the data from 1 server to other server...its like.. If i execute the package today, I have to get the data from tbljune in 1st server to tbljune in the 2nd server and also previous month data tblmay...for each month, I ve to get the data for that month and previous month...to be more clear..if we execute the package in february, we ve to get the data for tblfebruary and tbljanuary(tbljanuary->tbljanuary, tblFebraury->tblFebruaty) and if we execute the package in march, then we shud get the data for tblMarch and tblFebruary.....Is it possible with ssis??
any help would be appreciated...Thanks in advance...
June 13, 2008 at 3:51 am
For sure its possible....
First lets conceptualise a little, you basically need something that will return 2 dates to you - current month and previous month.
Everything will be based on these 2 months.
Now, what you will need to do is work with some variables which you will set in your scripting task. This is basically to be used to define your source table as well as destination table.
Then with one script you could go and reset your oledb source and oledb destination, whereafter you have the normal dataflow task
But its going to require a bit of research (to get the source and destination table reset)
Good luck
~PD
June 13, 2008 at 4:08 am
Thanks a lot...let me try that...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply