DTS Referece Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bala (Bala_at_discussions.microsoft.com)
Date: 08/03/04


Date: Tue, 3 Aug 2004 15:23:01 -0700

Hi,

i am exporting data, access to sql server. so for that i creatd the DTS Package and save as visual basic module and then from vb i'll exuectue the package.

so for this i have added these files into reference.
1.Microsoft DTS Customer Tasks object Libary
2.Microsoft Data Formating Ibhect Library 6.0 (SP4) (i am not sure this one required)

now i made a package and install it in client machine.

everything is ok. when try to open the sql server i got this error.

Fatal error:
Execution can not continue as the language dependent source file c:\program files\project1\Resources\1033\DTSPKG.RLL Could not be loaded.

i am sure some of the supported files are missing. but i dont know what are they.

can anyone please help me.

thanks
bala



Relevant Pages

  • 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)
  • Re: DTS Packages fail when executed from Jobs
    ... Action Plan 2: It runs fine on the server when run from the DTS Designer. ... 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)
  • Re: Problems launching DTS package from Stored Procedure
    ... I cannot really believe that EM is not installed on your SQL Server, ... sure if you can even install SQL Server without tools, ... machine to run a DTS package. ... >>>my DTS package consists of a table drop, a table creation, a connection to>>>Foxpro, a query to retrieve the data and a connection to SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Security
    ... the package due to the guest account being enabled in msdb ... where SQL Server is installed. ... >the DTS package. ... >> Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • Re: DTS Package run from Access on a different server: Error -2147467259; access denied
    ... I have got around the original problem using the SQL Server Agent Jobs ... Set up a job for the DTS package and remove any scheduling. ...
    (microsoft.public.sqlserver.dts)