This is a package property you can set in the IDE. Open the package and look at the properties. You will see a property named MaxConcurrentExecutables. The default value is...

I have had similar happen to me. As there are multiple developers we always use don't save sensitive, in which case it always comes down to passwords. I always turn...

If your password parameter in the IDE is marked as sensitive and you have the security set to do not save sensitive then to be able to debug the package...

Find all of the relationships and turn on cascade delete, then all you need to is delete the company records.

https://stackoverflow.com/questions/6260688/how-do-i-use-cascade-delete-with-sql-server

Some things to try, make sure the For Each Loop is setting the file name in your variable correctly. Also ensure that the file name parameter is being used by...

This was a bug a few years ago that I am sure was fixed with an update to Data Tools (SQL Version not Visual Studio version). I went through it...

You could create a calculated field which is a composite of the other fields making sure you use ISNULL() on the field that can be NULL to convert it to...

Nothing is leaping out at me from your code to cause a bottleneck.
If it is taking a long time to load the data into the staging table before any...

As Phil said, it should be very quick, even with the data conversion. Have you got any indexes on your staging table? Multiple indexes will slow your write speed down....

I believe it does work but only for the objects you have chosen to script, which is a shame as it would be really useful to have the permissions without...

You could try this. Use a Merge Join Task and set it up as a Full Outer Join taking the input from File A and File B. Make sure all...