Hello,
I have 2 SSIS packages. Basicaly they do the same thing except Package_1 is using configuration file and Package_2 doesn't.
Configuration file has 3 variables, Extract_Start_date, Extract_End_date, and Historical_load, depending on Historical_load value StartDate and EndDate get value either from config file or produce their own values. (if Historical_load ==1 then get from config) Package_2 use static StartDate and EndDate(not getting from config file)
The purpose of these 2 package to load historical data month by month(you can see the message in script task). The script task prepare months array and passing to the for each loop container. In container I will call stored procedure month by month until end of the .
The problem is process doesn’t work when use the config file.
Can anyone help me for this issue?
Appreciate your help in advance.
I have 2 SSIS packages. Basicaly they do the same thing except Package_1 is using configuration file and Package_2 doesn't.
Configuration file has 3 variables, Extract_Start_date, Extract_End_date, and Historical_load, depending on Historical_load value StartDate and EndDate get value either from config file or produce their own values. (if Historical_load ==1 then get from config) Package_2 use static StartDate and EndDate(not getting from config file)
The purpose of these 2 package to load historical data month by month(you can see the message in script task). The script task prepare months array and passing to the for each loop container. In container I will call stored procedure month by month until end of the .
The problem is process doesn’t work when use the config file.
Can anyone help me for this issue?
Appreciate your help in advance.