SSIS EXPORT TO EXCEL DIFFERENT RESULT THAN DTS EXPORT

• fotograf

  Grasshopper

  Points: 17

  More actions

  June 12, 2008 at 3:13 am

  #125816

  I have now spent 3 days on finding a solution for this problem.

  I export data from a table with a money data type column to excel. Before I do the export I'm creating the table in excel with a create table statement in "Execute sql task editor" like this:

  CREATE TABLE `test` (

  `MYmoney` Currency)

  in the datapump I use OLDB source (local sql server) and destination OLE DB connection (excel destination).

  When I open up the excel spreadsheet the Mymoney column will show dollar sign. The problem is that it should be Swedish kr currency showing. WHen I'm running the old DTS package in "Microsoft sql server dts designer components" in sql 2005 on the same server this result will be in the currency kr as it should be.

  When I'm running the SSIS on my local machine the result also get right.

  Any ideas?

  Thanks

  /Tobbe

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  June 12, 2008 at 7:24 am

  #827830

  Check the Regional and Language settings on the server in the control panel.