Re: Strange behaviour of DTS

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 07:19:29 -0000

I can only presume that this is like the issues with MDAC. If a user with
an Upstream version of MDAC saves a package then the properties of his/her
MDAC release are saved within also. A person coming along to execute the
package with a lower version of MDAC may experience problems because the
upstream version has properties not available in the lower version. 

-- 
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:e2Wtxn1$DHA.2292@TK2MSFTNGP12.phx.gbl...
> Hi,folks
> SQL Server 2000(sp3) with W2000 Server
> We have experienced recently with strange behaviour of our DTS package.
> We transfer data from AS400 to SQL Server (the package was created on the
> server side) and sometimes
> we get reversal hebrew words.
> We have found this happened when the user did some changes within the
> package and saved it on his/her workstations.
> After that when we run the package we get incorrect result (reversal
hebrew
> words)  and we will have to save the package again on the server. I cannot
> say this is happening on consistent/stable period, sometimes after saving
> the package on the server it does work and sometimes it does not.
>
> Can someone shed  the light on the problem. What is going on?
> What kind of settings should I check?
>
>

Relevant Pages

  • Re: Sql Server Agent (2000) erroring out on DTS Packages
    ... DTSRun: Package execution complete. ... and a problem with a missing MDAC dll. ... On Sql Server 7, this was SQLAgentCmdExec. ... Specified driver could not be loaded due to system error 126 (MERANT MSSS ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.programming)
  • Re: Migrating DTS Local Package from test to production environments v7.0
    ... The version of SQL Server on which the package was create is SQL Server ... DTS runs at the client so manually will be on the invoker's PC which in this ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Packages fail when executed from Jobs
    ... Action Plan 1 - Modify the path of Dtsrun.exe ... Expand the server that is running SQL Server in SQL Server ... Action Plan 2 - Run the DTS Package on the server rather than on ...
    (microsoft.public.sqlserver.dts)