Hi there,
At work we have a DTS package which exports a table to a CSV file. Now we are using exactly the same DTS package ( the DBA copied all the settings) to export other tables to CSV. Our external provider says these new CSV don't have the same encoding (?) ... using Notepad++ I can see all of them are DOS\Windows, ANSI.. but they are saying they don't have the same ISO (???!!)... I have been digging and (because is a CSV and not a XML) reading the file header is not so easy. Notepad++ detects the encoding as ANSI, but does not say what ISO is being used.
Can this be changed in the DTS settings? or the Integration Services settings?.. I don't have DBA access so I am flying in the dark here.. any suggestion will be much appreciated 🙂
Thanks,
Alexandra