| Author |
Topic |
|
sgandhi
Posting Yak Master
115 Posts |
 Posted - 2009-02-26 : 13:29:25
|
| Hi, i was wanting to know if i can do this and if yes how. I currently have a package that creates multiple excel files in the local language. This works fine. But i want to create the same files in english language has file. The columns all come from a single table in the source. THe output files will both look the same just have different language data in it.Can this be done in the same package. If yes how to do i specify for it to pick up diffent columns from the source for the english language file.Can anyone help with this |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-02 : 13:11:05
|
| i think you can use unicode fields for creating and storing flat files with different language data |
 |
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-03-03 : 10:52:34
|
| Hi, thank you so much for your help so far. I really appreciate it.My next question is. The file is exporting to an excel file. But my problem is, its putting a single quote in front of the text.EG:'1234THis you can see in the formula window in excel. How do i remove the single quote |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-03 : 11:06:30
|
| use SUBSTRING() function inside a derived column task and map it to destination instead of original column |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-03-03 : 11:20:26
|
quote:
Originally posted by visakh16
use SUBSTRING() function inside a derived column task and map it to destination instead of original column
Hi Visakh,i derive the column as this SUBSTRING(Action,1,255)but it still puts the 'ADD in front. I want it to just say ADD |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-03 : 11:25:49
|
| it shud be SUBSTRING(Action,2,255) |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-03-03 : 11:28:04
|
quote:
Originally posted by vijayisonly
it shud be SUBSTRING(Action,2,255)
When i do that it returns the following'DDIts cutting off the A, which i dont want. It doesnt read the single quote |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-03 : 11:37:38
|
| Is it ok if you format this in excel? If yes, check this.http://www.mrexcel.com/forum/showthread.php?t=77320 |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-03-03 : 11:40:03
|
quote:
Originally posted by vijayisonly
Is it ok if you format this in excel? If yes, check this.http://www.mrexcel.com/forum/showthread.php?t=77320
No because i am creating 60 files, on a regular basis, so i need something that will be automatic. Is there anyway in SSIS for it not to put the single quote in. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-03 : 12:34:48
|
| whats the datatype of field in source and destination? |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-03-03 : 13:20:18
|
quote:
Originally posted by visakh16
whats the datatype of field in source and destination?
string |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-03 : 13:34:51
|
| The single quote only depicts the numeric value to be a string. It does not create any other confusion.Whats the issue with the single quote? Are you doing some kind of calculation on those fields. Why dont you try defining it as Integer if all values are numeric? |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-03-03 : 13:58:12
|
quote:
Originally posted by vijayisonly
The single quote only depicts the numeric value to be a string. It does not create any other confusion.Whats the issue with the single quote? Are you doing some kind of calculation on those fields. Why dont you try defining it as Integer if all values are numeric?
We are using this output file that i am creating to upload using a GUI interface, and it errors over there cos of the apostrophie. This is why i want the apostrophie removed |
|
|
|
|
Single Quote in Exported Excel Files