my advise is to look at https://www.connectionstrings.com/ and see lots of possibilities - and obviously the manuals may have a bit more options.

most important thing for now is ensuring that backups are done to all db's.

For new server - first of get it setup - make sure the server will allow for...

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