Looks to be a double post >
https://www.sqlservercentral.com/Forums/1882132/Expression-needed-for-Midnight-of-previous-day?PageIndex=1

What is the actual max length of the values in that column? For instance varchar(20) give me up to 20 but I may only get at most 5 characters in...

At a very high level, keep in mind that: 
facts are numbers, 
dimensions are words (to describe the numbers). 

As for loading , that can depend on your business...

Just a quick reminded that you do have the ability to redirect those error rows to a predetermined location , like an errors table and not hold up the rest...

It is always good to have some sample data for better clarity. 

Maybe this will help wrap your head around problem. It is a simple illustration that you can...

Agreed. Not sure how it turned out for the OP but this is one where I would push back or at least wipe my hands clean of the bug being...

What is the exact data type of that one field that stores the email message body? Does your new private database support the XML type?

I would think that you already have a copy of these tables from the most recent backup. What is the "private" database that you want to migrate only some tables...

Maybe coordinate with your team to determine who can have access to the file and when. That is what file and folders permission are also built for 🙂 . As...

Are you using quotes around the values in the export? How lengthy is the field(s) that is causing the issue? How are you creating the files?
If migrating a database...

So is this a SQL Server log or a RedGate log? I guess that is what you are wondering. I dont use RedGate personally but you mention source control, the...

If your RRN schema was instead DBO, then the schema "dbo" would be the owner of all the objects involved. As it stands the DBO owner cannot access those what are...

And of course let me not forget... In SSMS you can simply type CTLR+SHIFT+F and that will put the results of the query to a file you define at run...

To export a column to a file>
I took this example from 
http://mytechmantra.com/LearnSQLServer/How-to-Export-records-from-SQL-Server-to-Text-File-using-BCP/

EXEC xp_cmdshell 'bcp "SELECT Name FROM [AdventureWorks2012].[Person].[CountryRegion]" queryout "C:\Temp\CountryRegion.txt" -T -c -t '

The place where I know the dimension key(s) are defined is when creating the dimension through the wizard. I choose 'use an existing table' and select the date dimension from...