when using SSMA my advise on migrations is to do data separately - let the tool convert objects (where it can) and do data yourself - more control of when/what...

multiple things.

• start with archiving the data onto a different server - partitioned by year/month - will help querying in some ways (not so in others) and will make deletes...

put them on the latest compat mode - if there are issues with CE you can change each db that requires it by using the ALTER DATABASE SCOPED CONFIGURATION  (see...

setup some Extended Events to capture all sql alongside host where it originated and username - let it run for awhile and that will tell you whats/who is doing it

please take this as a constructive comment.

had a look at that particular offer - not quite just a DBA - and it mentions skill sets that most DBA's will not...

as I told you if you define the field as a datetime datatype the format you use does not matter - it is up to the UI to do the...

if the fields were defined correctly as dates then the format does not matter

apart from that your code is doing what you asked for

you can't.

SSIS Catalog packages execute on the server where the catalog is installed so your setup needs to be

Server A

- SQL Server Instance

- - User databases

- - ReportServer db's -...

(First, a disclaimer.  I'm not by...

Thanks. I'm not sure I buy the "talk to MS/licensing reseller" mentality - they're the ones who told me 'per core, per server'! 🙂

Totally agree with this though:

"Now should...

its not per instance you only license the VM (or physical server ) - for SQL Standard on a VM environment you license all vcores on that VM (minimum of...

possibly use a execute sql task instead of a dataflow - resultset

pass this resultset to a component script and for each record retrieved create a new file and write the...

not being able to see the history may be other permissions being set or SSMS having issues.

or... too many jobs on the server and the history for the jobs he...

are all files the same format or different formats?

and when you say they are delimited (space in this case) with double quotes as field delimiter - is that really correct...

error is pretty clear - produit.sales.SalesOrderDetail_2014 is not partitioned - the image you posted is for the table sales.SalesOrderDetail

if your partitions are yearly and if you archive onto 1 table...