I am not suggesting that you jump ship every time someone offers you more money. However, as a contractor working on contract lengths of 3-6 months, when my contract comes...

'I have to ask where do you live? Cause you are not going to get that kind of savings in the metro atlanta area. '

You should be able to get...

As it turns out, and after much research, I had to switch the execution of the stored procedure from a OLEDB Data Source Connection to a ADO.NET Data Source.

The parameters...

I explain being a Data Architect like this:

If we were building a house, I would design, dig and pour the foundation.

Once my work is done, then everyone else comes...

You should be able to put the server in Maintenance Mode and make adjustments that way.

To do so, from the Services Window, stop the sql server and then add -m...

I guess I need to clarify my question more.

My plan is to load the data one partition at a time by loading a staging table and then merging it into...

The effects of setting that option are consistent with what I saw. My data sources were also configured from a table and that is how it was easily able to...

As it turns out, it was an issue with connection pooling with OLE DB connections.

I was able to capture the following error:

TCP Provider: Only one usage of each socket address...

SteveB,

Yes, every package has many script tasks for logging and statistics capture. The error window is something that I may look at. Everytime I open a package, I get an...

How did you work around the issue of waiting on a modal window?

The funny part of the code is that the two statements always follow one another with no other code in between.

I was thinking that somehow the code was throwing data...

There is another option since you are using c#.

Create the necessary GUIDs before you insert the rows into the table and pass them into the Database.

This way you do not...