March 7, 2011 at 5:23 am
Hi guys,
I would like to use tablediff[.exe] to synchronize my dimension-tables on different databases/server.
I generated a SSIS package that executes the tablediff-Commands.
Then the package executes the SQL-Statements generated by tablediff as Execute SQL Task.
As I looked with an Editor the file generated use UTF8 but the SQL Task does not translate the Charset correctly. The codepage you can define in the task is just used for the variable-Translation.
Where can I declare, that the file which is holding the SQL-Statements is UTF8?
March 7, 2011 at 7:36 am
I have been looking around the net a bit, but I don't seem to find a solution for your problem.
You could try to convert the file to a more appropriate encoding using a script task.
Anyway, this is a bit of a bummer from SSIS, they should be able to read such files without a problem.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply