CODEWITHSUNDEEP
sql-serverloggingencodingssisflat-file
StackUser
StackUser

Reputation: 5398

Change the file encoding of the file which is created using SSIS Log provider for Text Files

I am new to SSIS, I have already designed a package and configured SSIS Log provider for Text Files. This works fine and log files are generated successfully.

We have a monitoring team, they use this log file for monitoring. They are unable to read the log files since the file encoding is in Unicode format. They are expecting a non unicode format for their monitoring.

I tried to change the existing log file encoding to ANSI but when I re-run the package my log file has been created again with UNICODE encoding.

Is any way we can create log files using SSIS Log provider for Text Files with non unicode encoding. Kindly suggest me any workaround. I am unable to find solution for the past two days.

Upvotes: 2

Views: 1008

Answers (1)

Hadi
Hadi

Reputation: 37313

Trying to figure out the issue

Since SSIS Log provider for Text Files use a File connection manager for logging purposes, you don't have the choice to edit the file encoding within the SSIS package because this type of connection manager can be used for different files format (excel, text ...).

While searching for this issue it looks like if the log is created for the first time by SSIS it will write unicode data.

Possible workaround

Try to create an empty text file using notepad and save it with ANSI encoding.

enter image description here

Then select this file from the SSIS logging configuration.

Other helpful links

Update 1 - Experiments

To test the workaround i provided i have run the following experiments:

  1. I add SSIS Logging and created and a new log file

enter image description here

  1. After executing the package the file is create in Unicode (to check that i opened the file using notepad and click Save As the encoding shown in the combobox is Unicode)
  2. I create a new file using Notepad and save it using Ansi encoding as mentioned above.
  3. In SSIS i changed the File connection manager to Use Existing instead of Create New and i selected the file i created

enter image description here

  1. After executing the package the log is filled within the file and the encoding is still Ansi
  2. I repeated executing the package several times and the undoing wont changes.

TL DR: Create a file with ANSI encoding outside the ssis package and within the package create a file connection manager, select Use Existing option and choose the created file. Use this file connection manager for logging purposes.

Upvotes: 1

Related Questions