I am trying to do something very similar, but I am not sure how to go about creating destination file property a variable with "evaluate expression" true. Can somebody...

Why can't you simply replace "," with "." before passing the value to SQL?

Try creating a new bcp format file using

bcp MBLOGS_DEV..AuditJournal out c:\fmtAuditJournal.txt -Sservername -Uuid -Ppwd

The new file should have default collation.

Hope it helps!

Turn on Just in Time debugging option -

1. In the SQL Server Enterprise Manager console tree, right-click the Data Transformation Services node, and then click Properties.
2. Select the Turn on just-in-time...

Run the following script (ammended version of post by  Journeyman).  Result will be 1.

CREATE TABLE #TestUpdateA (ColA Char(1),ColB Int)

GO

CREATE TABLE #TestUpdateB (ColA Char(1),ColB Int)

GO

INSERT INTO #TestUpdateA VALUES('A','0')

GO

INSERT INTO #TestUpdateA...

An auto-created statistic starts with the prefix _WA_Sys and is not "named _WA_Sys"

How do you insert results of sp_who2 in a table?