Try 

if object_id('tempdb..#t','U') is not null
drop table #t;

create table #t
(x int
);


e.g. remove the GO statement (that is probably what...

I had Snapshot and Transactional replication setup from a 2016 to a 2008 R2 without any issues for a short period. No issues with it.
2016 - both replication and...

Look to see if the SQL server instance user has IFI privilege - https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-instant-file-initialization?view=sql-server-2017 
and make sure that the log file has enough size to cope with the transaction -...

easiest way for you to find out is to test it yourself on a DEV instance.

you running that on your machine or on the server through cmdshell or sql server agent job? if on the server the files need to be on the server C:...

Free versions already mentioned.
For paid versions
RedGate - SQL Prompt 
DevArt - SQL Complete
Neither completely good, one better on particular things, the other better on other things. DevArt...

can you post the sql you using as your source on the dataflow mentioning which column is giving you the undesired result.

Taking in consideration what the output is I do not believe that you are doing a convert to decimal 38,10 on source, neither is the output defined with the same...

Could you post the C# code here so we can have a look at it and eventually suggest any modification.

And it will always be slow - just not...

Trick is "do not use SSIS".
SSIS is very slow with clobs regardless of the driver used (possible exception of third party ones like CozyRoc and similar as i do...

Luis, I think you failed to understand what others were trying to explain but as I may be wrong can you explain to us how you will determine the content...