VS has always seemed a little glitchy to me, but I attributed that to my lack of understanding.  Given that the files loaded, I may not need to run it...

Yes, the files loaded.  I could deploy and run it from an Agent job...I may try that to see if anything changes.  Thanks!

As it turns out, the old linked server had 'Be made using this security context' set within Properties>Security and the new one did not. That has been addressed and now...

Thank you!

I really appreciate your advice and insight. I can see that XE can be a very useful tool that will highlight any issues over time.  I'm going to keep it...

Alejandro,

I have started the XE. At what point would I stop it?

I'm seeing a few deprecation_final_support notifications in the package0.event_file, but nothing truly alarming.

Thanks for providing the code for this,...

C:\Program Files\Microsoft Data Migration Assistant\DmaCmd.exe /AssessmentName="DMA_Output_testmdb" /AssessmentDatabases=

"Server=ServerName;Initial Catalog=testmdb;Integrated Security=true" /AssessmentEvaluateCompatibilityIssues /AssessmentOverwriteResult /AssessmentResultCSV=

"\\sharedrive\InfoSvcs\UserC\ServerName\testmdb.CSV" > "\\sharedrive\InfoSvcs\UserC\ServerName\testmdb.LOG"

• This reply was modified 5 years, 3 months ago by  alicesql. Reason: For readability
• This reply was modified 5 years, 3 months ago by  alicesql.

Thanks for all your responses. The vendor is requiring the compatibility level change to  ensure that their Meaningful Use code works correctly. My understanding is that running the DMA will...

I think I've got it!  The problem was with the flat file connection manager after all.
I changed it to Delimited and used a Column delimiter of CR and a...

I have created a staging table as suggested.

CREATE