asked
sequence container with 2 or more data flows not loading data in SSIS
I am in the process of loading the data from Oracle to MySql in AWS. Each data flow will be loading around 6 hundred thousand rows. Running each data flow at a time is no issue at all. I tried to run/execute around 5 or 6 data flows using sequence container. I started around 5:00 pm and when i came the next day around 8:00 am, the process was still running and i see only few rows been loaded into the tables. I increased the Amazon instances from 3 CPU's to 6 CPU's and from 15 gb of ram to 30 gb of ram. Almost double. But still i was not able to get the output. My question is, how can i speed up the Sequence container to load the data faster. Any help would appreciate it much. Thanks,
Does anyone have any answer to this?
17 People are following this question.
