Running DTS packages

  • Thread starter Thread starter Rob Oldfield
  • Start date Start date
R

Rob Oldfield

I have some code that I stole from MSKB article 321525 that I'm using in a
windows forms app (framework 1.1, VS 2003) that I'm having some problems
with.

Basically, if I try using it on a machine that only has the framework
installed, then it fails intermittently. If I use the code on a machine
that has had SQL installed onto it, then it works perfectly. Running a file
monitor over the machine that works shows that it is actually using the dts
files (e.g. dtspump.dll) installed under c:\program files\microsoft sql
server instead of just using framework files.

I'm thinking that next week I need to contact MS to say "What's wrong with
321525?" but, in the meantime....

Could someone confirm that I really shouldn't need the locally installed dts
files

and

Has anyone else had the same kind of problem with 321525? Any solution?
 
Rob,

I am not familiar with the article, but I'd still suggest it DOES require
the SQL Server Client Library to be installed. It's unlikely the Framework
itself implements this functionality, it rather relies on SQL Server DLLs to
do the job.
 
Can't say I'm convinced. If it definitely requires the library then
how does it work intermittently (generally the first time the app gets
installed and then infrequently afterwards) on machines with no
library?

Going back to the file viewer I'm using, when it works on
non-library-enabled machines, it just utilises files under the
framework folder.


Dmitriy Lapshin said:
Rob,

I am not familiar with the article, but I'd still suggest it DOES require
the SQL Server Client Library to be installed. It's unlikely the Framework
itself implements this functionality, it rather relies on SQL Server DLLs to
do the job.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

Rob Oldfield said:
I have some code that I stole from MSKB article 321525 that I'm using in a
windows forms app (framework 1.1, VS 2003) that I'm having some problems
with.

Basically, if I try using it on a machine that only has the framework
installed, then it fails intermittently. If I use the code on a machine
that has had SQL installed onto it, then it works perfectly. Running a file
monitor over the machine that works shows that it is actually using the dts
files (e.g. dtspump.dll) installed under c:\program files\microsoft sql
server instead of just using framework files.

I'm thinking that next week I need to contact MS to say "What's wrong with
321525?" but, in the meantime....

Could someone confirm that I really shouldn't need the locally installed dts
files

and

Has anyone else had the same kind of problem with 321525? Any solution?
Click to expand...
Click to expand...
 
Back
Top