Using VB and DTS

Posted on 2009-04-08
Last Modified: 2013-11-30
I have a vb application working with DTS.  All works fine when I have SQL installed on a local PC but when I execute the application from a machine that does not have SQL installed it does not load the data and trows a run time error:
Run Time Error '52,
Bad File name or Number

I used VBs package and deployment wizard to set up the application to ensure I had all the dlls.  I reregisterd the dtspkg.dll file but no joy.

Is there something else we need in order to run this?

Any help would be great

Question by:ITHELPME
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1

Accepted Solution

Haris V earned 250 total points
ID: 24096833

Author Comment

ID: 24097779
Thanks for your help, None of the sites suggested had anything regarding running it from an in-house application as opposed to a vb application

Is there anyting I need to install on the users pc in order to run dts
LVL 30

Assisted Solution

nmcdermaid earned 250 total points
ID: 24103107
What do you mean by 'in-house' vs 'vb'? in-house means it was developed in house and vb is just a language.
There is also this page:
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.


Author Comment

ID: 24105222
It is an application installed witihin the organanisation and vb is the programming language that is used.

When I register the dlls on the machines it gives me an error indicating that they may be corrupt, is there a plcae where I can download the correct dlls and more uptodate onces.

We use Win2k Professional

LVL 30

Expert Comment

ID: 24115012
From a licencing standpoint, you can't just go and register DLL's, you have to buy a licence and install the whole thing.
You would need to register them in the right order (or put them in the same folder as your executable), and you would also need to ensure they suit your OS (x86 or x64)
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24124197
Run Time Error '52,
Bad File name or Number
You do realize this error has nothing whatsoever to do with the DTS dll's?  The error is simply telling you that the workstation executing the DTS package does not have access to the file.  So even if we were to clarify that you are allowed to distribute the DTS dll's and how to do it, it would not help you one iota with our original problem.
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24124205
And this:
our original problem.

Of course, should have read:
your original problem.

Author Closing Comment

ID: 31570376
It was the registering of the DLLs

I did not only get run time error this only happend once, the websites were helpful

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question