Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
toby1
Starting Member
8 Posts |
 Posted - 2008-06-12 : 05:26:17
|
| 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 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-12 : 05:43:43
|
What locale, region setting, does the sql server have where ssis is installed?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
toby1
Starting Member
8 Posts |
Posted - 2008-06-12 : 05:55:36
|
quote:
Originally posted by Peso
What locale, region setting, does the sql server have where ssis is installed?
E 12°55'05.25"N 56°04'39.16"
Hi,I have choosen Swedish for regional options. If I look at the samles showing there under currency I can see Currency kr showing right. But I use the exact same regional settings on my local machine and that works ok. Also When running the old dts package on the remote server things are working great, unless I'm running new SSIS pakage on the same remote server the $ sign will be in excel sheet. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-12 : 06:07:20
|
quote:
Originally posted by toby1
quote:
Originally posted by Peso
What locale, region setting, does the sql server have where ssis is installed?
E 12°55'05.25"N 56°04'39.16"
Hi,I have choosen Swedish for regional options. If I look at the samles showing there under currency I can see Currency kr showing right. But I use the exact same regional settings on my local machine and that works ok. Also When running the old dts package on the remote server things are working great, unless I'm running new SSIS pakage on the same remote server the $ sign will be in excel sheet.
There's a property called LocaleID for the SSIS package. Are you sure you've set it to Swedish for that property? |
|
|
|
toby1
Starting Member
8 Posts |
Posted - 2008-06-12 : 06:09:19
|
| Locale ID is swedish (sweden) on everyting in this package. |
|
|
|
|
|
|
SSIS EXPORT TO EXCEL DIFFERENT RESULT THAN DTS EXP