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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2009-05-20 : 07:11:17
|
| Hi I need ebcdic to ascii conversion through SSISmy input file is òóôõö÷ãñòóKñò@@@@@@@ðððððððöõø÷òÅ Cðññò@@@@ððóðññ@ Slðõô@ Rlðøù@ eBlñòóôõö÷ãñòóKñò@@@@@@@ðððððððñòø÷òÅ! Cðññò@@@@ððóðññ@ Slðõô@ Rlðøù@ really big thing???help me outT.I.A |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-21 : 02:34:29
|
See if you can find a collation for EBCDIC.If you are using EBCDIC 037, use this collation SQL_EBCDIC037_CP1_CS_AS
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2009-05-21 : 08:07:03
|
| thanks!I have this colletion in DB but i need more information regarding the text that i need to convert..means how i should create table then column where this text need to import..how i shud seperate these text into columns (like deliminator)...T.I.A |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-21 : 08:11:54
|
Probably. You must understand that this question is really hard for us to answer since we don't know ANYTHING about the data.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2009-05-21 : 08:20:34
|
| no i am asking in general how we shud approach such text file.. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-21 : 10:11:59
|
Oh.You should use a FORMAT FILE.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
ebcdicguru
Starting Member
1 Post |
Posted - 2009-06-16 : 15:41:27
|
| You may also consider a 3rd party component if you don't want to become an EBCDIC expert. There is one at www.aminosoftware.com with a free trial, give it a try! |
|
|
|
|
|
|
ebcdic to ascii conversion through SSIS