http://www.greymatter.com/product/Microsoft/SQL-Server-Developer-Edition/656784#

have you tried RDP to the server (using the Sql Server agent ID) and then running the package from a windows command line with the DTEXEC command?

or even on...

will the following satisfy your need for simplicity?

create view [table_normalized]

as

select t1.PersonID

, t1.col_name

, t1.col_value

from ( select t1.PersonID

...

Installing Visual Studio 2015 does not prevent you from installing Sql Server Data Tools for visual studio 2012 or 2013 - you can have all 3 versions installed of SSDT...

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