connecting AS400

hi all,
we are running a dts that migrates data from an as400 to sql 2K.
the string data is hebrew (code page 1252).
for that, we have been using a hit odbc:
ODBC OPTIMIZED (READ ONLY) 32 BIT
VERSION 4.00.06.20
HIT SOFTWARE, INC
untill now we were running the dts from sql 7.0 and that worked well.
the porblem started after copying (and then rewriting) the package to sql 2k:
when running the dts manually (execute package) it's o.k, but when running
the dts via a job the hebrew characters are being mirrored in the sql 2k.
(e.g, written from left to write instead of right to left).
again, in sql 7 it worked well both ways.
some details:
-in both cases (job and manually) we execute the package from the same server.
-the win login account used for manual executing is identical to the log on
accounts of server service and server agent.
we are using a system dsn.
I have found in a newsgroup a tip to solve that: using a user dsn.
but when I tried that another porblem came up:
when running manualy - it was, again, ok
but when running via a job (or with dtsrun) the server couldn't find the odbc.
here is the error massage:
DTSRun: Loading...DTSRun: Executing...DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_2DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2DTSRun OnStart: DTSStep_DTSDataPumpTask_1DTSRun
OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error
string: [Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified Error source: Microsoft OLE DB Provider for ODBC
Drivers Help file: Help context: 0Error Detail Records:Error:
-2147467259 (80004005); Provider Error: 0 (0) Error string: Error
source: Help file: Help context: 0DTSRun OnFinish:
DTSStep_DTSDataPumpTask_1DTSRun: Package execution complete.NULL
so.. any help will be usefull (regarding the hebrew mirroring or regarding
finding the user dsn)
thanks,
elad.
Elad, shalom
I assume you got connected by using Client Access to the AS400.
Look , first of all it depends on lot of things
1) Right click on the server within a package and press "Advance" button.
Under Property name you will find Auto Translate=1 or =0. Try to play with
it.
" " <@.discussions.microsoft.com> wrote in message
news:12A0B201-3D38-4626-9DD1-155623940393@.microsoft.com...
> hi all,
> we are running a dts that migrates data from an as400 to sql 2K.
> the string data is hebrew (code page 1252).
> for that, we have been using a hit odbc:
> ODBC OPTIMIZED (READ ONLY) 32 BIT
> VERSION 4.00.06.20
> HIT SOFTWARE, INC
> untill now we were running the dts from sql 7.0 and that worked well.
> the porblem started after copying (and then rewriting) the package to sql
> 2k:
> when running the dts manually (execute package) it's o.k, but when running
> the dts via a job the hebrew characters are being mirrored in the sql 2k.
> (e.g, written from left to write instead of right to left).
> again, in sql 7 it worked well both ways.
> some details:
> -in both cases (job and manually) we execute the package from the same
> server.
> -the win login account used for manual executing is identical to the log
> on
> accounts of server service and server agent.
> we are using a system dsn.
> I have found in a newsgroup a tip to solve that: using a user dsn.
> but when I tried that another porblem came up:
> when running manualy - it was, again, ok
> but when running via a job (or with dtsrun) the server couldn't find the
> odbc.
> here is the error massage:
> DTSRun: Loading...DTSRun: Executing...DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_2DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_2DTSRun OnStart:
> DTSStep_DTSDataPumpTask_1DTSRun
> OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
> Error
> string: [Microsoft][ODBC Driver Manager] Data source name not found and
> no
> default driver specified Error source: Microsoft OLE DB Provider for
> ODBC
> Drivers Help file: Help context: 0Error Detail Records:Error:
> -2147467259 (80004005); Provider Error: 0 (0) Error string: Error
> source: Help file: Help context: 0DTSRun OnFinish:
> DTSStep_DTSDataPumpTask_1DTSRun: Package execution complete.NULL
> so.. any help will be usefull (regarding the hebrew mirroring or regarding
> finding the user dsn)
> thanks,
> elad.
>
>
>
>
|||hi Uri,
well, I used the HIT odbc for as400.
here are it's details again:
ODBC OPTIMIZED (READ ONLY) 32 BIT
VERSION 4.00.06.20
HIT SOFTWARE, INC
and, for that odbc I couldn't find a auto translate property.
I also looked for a download of the client access odbc but couldn't find it.
so... I will thakfull for a link
thanks,
elad.
"Uri Dimant" wrote:

> Elad, shalom
> I assume you got connected by using Client Access to the AS400.
> Look , first of all it depends on lot of things
> 1) Right click on the server within a package and press "Advance" button.
> Under Property name you will find Auto Translate=1 or =0. Try to play with
> it.
>
>
> "Xìò? ùì?X" <@.discussions.microsoft.com> wrote in message
> news:12A0B201-3D38-4626-9DD1-155623940393@.microsoft.com...
>
>