no

no easy way to log the SSIS logging to sql server agent log.

one way would be to change the job to execute a cmd file containing 2 steps

step 1 -...

going to reply to your 4 comments.

1 - you do not need to migrate to Microfocus - I was just stating what we did on our project.

regarding the...

I've done such a migration 4 years ago - migrate a IMS db to Sql server and mainframe cobol to Microfocus COBOL. we kept the core code in COBOL but...

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