Considering this is SSIS, I would suggest directing your failed rows to a different output (i.e. a text file) and then inspect those. We don't know your data or the...

No sure if that is your full DDL but you, it appears you're trying to insert the string value "<null>" into a column of the data type datetime.  You'll probably...

Completely agree that loading 500 tables in a single Data Flow task would unlikely be a good idea. Your data is going to have some kind of relationship definitions, so...

What do you mean by "day 1"? As in at product launch? If so, why not rollback to the pre-release version, as that should be the same?

That second XML isn't valid. The tag Order isn't closed. Sounds like, however, you need to pass all the values as an empty string ('')?

What do you mean by "not matching", different values? Perhaps the deployed report is using a different data source, and thus when the default value is calculated a different value...

Duplicate post of https://www.sqlservercentral.com/Forums/2019660/Looking-How-to-achieve-DBMSApplication-DBMSSession-DBMSOutput-in-SQL-server-2017

Interesting development on Stack Overflow, where they shared email addresses to Amazon without consent. This is a meta post on it (with response from one of their product managers):

You're still using execute(@query);. Like I showed above, you need to use parametrised SQL with sp_executesql.

P.s. I still really suggest getting some formatting and...

Remove the...

OK, that explains a lot more. We'll go with the simplified version again, but you need to parametrise your dynamic SQL, rather than passing the dates as literal strings. So,...

There's a few problems with that SQL you've posted. Firstly you have:
declare @frdate datetime =;01-jan-2019',@todate datetime ='31-jan-2019'
You have a wayward semicolon before your first date's value,...