yeahh.... and then it fails because of names that have the strings like this one "Southmoreland School District" or "northampton"

its a nearly impossible task without a table with exceptions and...

look for dbatools.io - with it you can script some, but not all of the objects, and can apply filtering.

and I may be able to post another script that does...

Can you tell more about these effects...

normally with Dynamics applications you can't enable CDC at all - and you just saw one of the effects of doing so.

enabling CT or similar is your best option -...

the time the SSIS package is taking to load the data is most likely related to how the processing is implemented than to how the partitions are setup - and...

or better yet - setup a powershell that executes all required queries and writes the output of each onto a csv file (one per query) - and set it so...

have a look in the manual for substring and convert, and potentially "stuff" - with the you will be able to do what you need.

and if after you read the...

you need to add " (double quote) as the text delimiter on the definition above - once you do that you will be able to open the file correctly in...

That's nice points you said. I was trying to automate this process using SQL Server agent job and selecting SSIS, once I have my export package saved. I tried...

what indexes exist on the parent table?

most likely there is one already covering all the columns on that where clause - and if so the effective date should most likely...

you don't need to measure everything - if someone asked you to do that they don't know what they are talking about.

and comparing a proc over all others on a...

could be due to login not valid.

How are you setting up your connection string to DB2?

and is it using username/password or other method?

A simple google gives this

changing to read only does not prevent access to it.

changing security may prevent those that need access to it to do what they need.

So if it needs to be online...

either switch it off or rename it (in case data is volatile and someone needs to look at the old content).

Either will prevent unwilling access to it as Anthony mentioned.