a toughy!

Hey all,
I have a bunch of data files that currently come to my shop in an EBCDIC format from IBM midrange machines and I currently use a Borland application to convert them to ASCII. I would like to ditch the Borland piece and do everything with a DTS package and get the data into my SQL2000 server...but how do I convert the EBCDIC to ASCII?

Please help!there are more ways and everything depends on how often you do it, how big files you have, how automated process you want...

I can tell you that the best is Informatica PowerCenter... for $200,000

I'm just kidding :)

you can use command-line conversion tool or ActiveX or your own function.

You can have your own function and use it in FIELD to FIELD mapping in DTS. The problem is, that it will take lot of time and for larger TXT files it is not the best solution.... Better would be to convert text file from EBCDIC to ASCII. There are some free command line programs ActiveX components (text file conversions). Check Google.com

I'd start with small function and you will see if it is really slooooow.

http://www.crystalsoftware.com.au/textpipe.html
http://www.guysoftware.com/parserat.htm

jiri|||Thanks, but I was really hoping to get my hands on some source so I could see how this works. I am not to keen about buying a 3rd party tool from a small developer because it will lead to a support nightmare 3 years down the road.

Has anyone out there tackled this ground up? I would love to see some source, even if its slow...heck I'd even be willing to taske a crack at some Perl.
-d

Originally posted by playernovis
there are more ways and everything depends on how often you do it, how big files you have, how automated process you want...

I can tell you that the best is Informatica PowerCenter... for $200,000

I'm just kidding :)

you can use command-line conversion tool or ActiveX or your own function.

You can have your own function and use it in FIELD to FIELD mapping in DTS. The problem is, that it will take lot of time and for larger TXT files it is not the best solution.... Better would be to convert text file from EBCDIC to ASCII. There are some free command line programs ActiveX components (text file conversions). Check Google.com

I'd start with small function and you will see if it is really slooooow.

http://www.crystalsoftware.com.au/textpipe.html
http://www.guysoftware.com/parserat.htm

jiri

A problem with SQL Integrated Windows Logins

I am working with 3 SQL 2000 Machines. I manage them by assigning Windows 2000 groups as logins. All of this is fine except that on one server, I belong to a Windows group which gives me certain rights.
I log into my Windows 2000 machine using my domain account which is in the Windows group, When I go into Enterprise Manager I get a message "unable to access default database" and I can not log in. If I put my Windows account into the SQL logins everything is OK. No one else has this problem and I only have it on one server. Anyone?Check the domain account default database. Maybe the account does not have access rights for the default database. (if not then map the account to that DB,or change the default database for another one which have the appropriate rights).
When you log in using Enterprise Manager, SQL checks only the login permission not the access rights, that's why the connection is allowed.

Originally posted by courtjs
I am working with 3 SQL 2000 Machines. I manage them by assigning Windows 2000 groups as logins. All of this is fine except that on one server, I belong to a Windows group which gives me certain rights.
I log into my Windows 2000 machine using my domain account which is in the Windows group, When I go into Enterprise Manager I get a message "unable to access default database" and I can not log in. If I put my Windows account into the SQL logins everything is OK. No one else has this problem and I only have it on one server. Anyone?|||Check with SP_HELPLOGINS.

A generic error occurred in gdi+

We have created an application that shows reports with the ms
reportviewer. But on some machines (like our Terminal Server) we see
the reportviewer on processing and than we recive this error: A generic
error occurred in gdi+.
Any ideas?
thxAdditions: We use VS 2005 and .Net Framework 2.0 and der Version of the
Report dlls is 8.00|||solved ... wrong report path *argh*
thx