Re: problem migrating data from as400

#1

For the DSN not found, have you created teh DSN on the server, as opposed to
your workstation?
Is it a system DSN, rather than a User DSN, and not the user context for the
SQL Server Agent service.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"???? ????" <@discussions.microsoft.com> wrote

Quote:

hi all,
I'm re-posting my question here.
it's seems more reasonable then posting it on the general forum.

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: problem migrating data from as400

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: problem migrating data from as400 - 08-25-2005 , 06:35 AM