Dynamically creating tables based on data for year

2019-08-21 09:16发布

I am trying to store approximately 11 billion records in the destination table by querying various source tables via inner join.

I would need to store the data based on Year and Quarter. There is a need to store data from year 2000 onward.

So I would have tables for e.g

FinData2015_1
FinData2015_2
FinData2015_3
FinData2015_4


FinData2016_1
FinData2016_2
FinData2016_3
FinData2016_4

I planned to create the physical tables right from year 2000 to 50 years from now and implement a split condition component in SSIS. So I would create in all 67 tables in all and 67 split conditions

See the screenshot below

enter image description here

Is there a better way to do this. That is creating table dynamically if data for that year and quarter exist

标签: ssis
0条回答
登录 后发表回答