is maxdop set to 0? this may cause some quite misbehaving queries to show up now. this should be set neither too high nor too low if your machine has...

have a got at it and come back with any issues.

But as I said SSIS really isn't the best option for parallel processing like this.

in any case here is another...

Normally means that you do not have Integration Services installed.

Run the SQL Server features discovery report to see if it has been installed both on your PC and on the...

Persavise does have a 64bit client - can't you use it?

Regarding the 32bit execution of SSIS packages you can do it - probably you will need to execute it...

you can do it - although I would not use SSIS for the controlling of the executiong of the loading - for this I would consider instead a C# or...

That does not invalidate the fact that you should use it...

First off you should look into using the Microsoft ACE (Microsoft Access Database Engine 2010 (or 2013) Redistributable) for reading the excel files as it does allow for a...

are you executing the package on the file system or on Sql Server? and if on Sql Server are you setting it to run asynchronously or synchronously?

if running asynchronously...

In my opinion it all depends on how big your SSIS process is going to be and if the existing servers have a window where the SSIS jobs can run...

These would be my toasters

Agent Ransack - searching for files is a must.

Vim ... (unix guy here so a must)

7zip

works only partially - does not take in consideration that fact that some countries do have Accented alphas so the code as is removes them.

Select dbo.fnTrimNonAlphaCharacters('âáÉéôô') will just return an...

nice post.

I have just one question which may help others also.

Does the fact that you are referencing the Excel object on SSIS require a Excel install on the server?