May 20, 2009 at 3:53 am
Hi,
I would to convert the ASCII to EBCDIC in SQL Server 2000?
Is there any function or System Stored proc is available for this?
Or
How do convert this?
Thanks in Advance.
May 20, 2009 at 6:12 am
There are some EBCDIC code pages defined since SQL Server 2000 so you need to check the BOL if yours is also defined, if it is defined you should be able to do it DTS because I have helped someone do it in SQL Server 2005 SSIS Execute SQL task.
If yours is one of those hybrid that is part numbers you need to find SSIS package to Unpack it because I think Microsoft posted some code online.
Kind regards,
Gift Peddie
May 20, 2009 at 9:24 am
Can you share some codes or steps?
It will be very helpful for us...
May 20, 2009 at 9:34 am
Here is the thread with many options you can use to do the conversion. Here is the Microsoft provided code page converter you could use that.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply