Gary Varga (4/21/2016)

I did bother....

did either of you bother reading my reply? if you don't supply the server to the cmdlet Get-WmiObject it will only do the current server

you were missing the -computer parameter

for powershell v3

Get-WmiObject Win32_LogicalDisk -computer (Get-Content c:\temp\computers.txt)|Select PSComputerName,DeviceID,VolumeName,Drive,DriveType,Size,FreeSpace|Export-Csv -NoTypeInformation -Delimiter "`t" -path c:\temp\alist.txt

the command above will output the values with double quotes -...

Gee.... this last post would warrant a holy war and a thread on its own.

Regarding the original post.

Before deciding on a ETL strategy you need to focus on what are...

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...