you can use these constructs to deal with partitions

select $partition.partitionfunctionname(partitioncolumn) as partitionnumber

,*

from mypartitionedtable

select *

from mypartitionedtable

where $partition.partitionfunctionname(partitioncolumn) = 5

see https://msdn.microsoft.com/en-us/library/ms188071.aspx

I see to main issues here

1 - VM setup seems to indicate an issue if performance of HD's is that bad compared to the physical.

What is the VM...

yes that would be the case - but easy enough to build the case statements in Excel for example - this is something I had to do on the last...

DCOM maybe? see http://answers.flyppdevportal.com/MVC/Post/Thread/c7f52891-7920-480c-999e-183d8f1b6387?category=sqlintegrationservices for some possible issues

select id

,product

,rentalrates

,row_number() over (partition by id order by RentalRates) as RowId

...

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