SSIS: globally set the Default Maximum Insert Commit Size

Is there a way to globally set the Default Maximum Insert Commit Size for the Destination Component in SQL Server 2012 SSIS (Visual Studio 2012)? I know I can change the value when I am configuring the values. I would like to have my own value loaded to the box when I open the Destination Editor. Would this be a registry hack?
LVL 7
shambaladAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

shambaladAuthor Commented:
Not much interest in this question I guess....
0
dameyCommented:
If you want to set or view in visual studio at run time you can view or set the value using dts object.
Dts.Variables["MyCaseSensitiveVariableName"].Value = ????

Is this what you'd like?
0
shambaladAuthor Commented:
I was hoping to find something I could set once for posterity.
Damey - If I don't get any better alternatives in the next day or two, I'll accept your answer.
Thank you for your help.
Todd
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

dameyCommented:
Thanks sham, I just re-read your post and I think I know what your trying to do, I was thinking in code for performance tuning these values can really make a difference in fine tuning.
But
If you want to set this you can add your own config files to the package.
Here is a tutorial on how to:
https://msdn.microsoft.com/en-us/library/cc895212.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shambaladAuthor Commented:
Damey -
Sorry for not getting back to you sooner. Been studying for the 461 Cert exam which I am taking tomorrow morning (who writes those questions?). I get back to this topic tomorrow afternoon. Thanks for your help.
Todd
0
shambaladAuthor Commented:
Good morning -
I'm looking at this right now. The Configuration file appears to be the solution I am looking for.
Will get back to you later today with the results of my investigation.
Thanks,
Todd
0
shambaladAuthor Commented:
Damey -
I find myself again apologizing for the delay in closing out this question. Setting up a config file is the solution, and I will accept your suggestion as the solution. Before I do that, though, I want to implement the config file, and include it in this question. When I sent you the last post, I thought we were going to working in an SSIS environment the following day in class. That did not turn out to be so. I just finished the school and got back home early yesterday. My plan is to set up an environment to create the config file later today (tomorrow at the latest). Once I have done that I will close this out. No matter what happens, I will close this out tomorrow. Thank you for your patience.
Todd
0
shambaladAuthor Commented:
Thank you for your help. When the time comes that I have set up the environment, I will return to this question to add the content of the configuration file.
Todd
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.