Solved

Question About DTS

Posted on 2002-07-10
6
160 Views
Last Modified: 2013-11-30
Hi everyone!  This is probably a simple question, but I'm a beginner using DTS.  

I have a VB application that executes a DTS package when a button is pressed.  Yesterday, while at one of our satellite offices, I tested the program from one workstation and it worked fine, but when I tried it from another I received an error (which I unfortunately forgot to write down).  The error was something vague - something about a "Multi-step OLE DB process failed to execute".  On the 2nd workstation, I even attempted to just execute the DTS package straight from SQL Enterprise Manager and still received the error, so I'm thinking that it doesn't have anything to do with the VB application.  

Can anyone tell me if a client machine uses any particular DLL's when attempting to execute a DTS package on a server?  Any ideas what may cause this?

Thanks,
Brian
0
Comment
Question by:beercat2
  • 4
6 Comments
 
LVL 5

Expert Comment

by:spcmnspff
ID: 7143669
Here's a good place to start:

http://www.sqldts.com/main.asp?nav=1,6,225,0

Although, it sounds to like there might be some resources that aren't available at the client that were at the server when the package was created.  Bear in mind that when executing the package at the server any references to files, network shares, etc need to be located on the server i.e. c:\ refers to \\mysqlserver\c$\ etc.  And when executed on the client (even from enterprise manager) all the resourcces are searched for locally i.e. c:\ now refers to \\localclient\c$\ .  This "local scope" issue can get in the way when attempting to redistribute your package and execute it anywhere other than the server.  The best way around it is to use the UNC paths (as I did in my examples).  This way any references to network resources are universal and absolute.
0
 
LVL 1

Author Comment

by:beercat2
ID: 7143694
Thanks spcmnspff.

I discovered the "local scope" issue you are referring to while developing the app.  There is 1 file involved, a CSV file, but the user selects the file with my app, so the path and filename are local to the machine where the app is running.  And I know it works on some workstations which have the same drives mapped as others where the app doesn't work.

I will be back in the satellite office tomorrow and will investigate the files listed on the link you sent me.  Thanks for your help - I'll let you know if this fixes it.
0
 
LVL 1

Author Comment

by:beercat2
ID: 7146822
No luck.  Both machines have all of the files listed on the SQLDTS.com website.  The problem occurs even if I'm working in Enterprise Manager and I remove everything except the first step - which is a simple SQL statement (a DELETE statement) - from the package.  I still get the error.

"Multiple-step OLE DB operation generated errors.  Check each OLE DB status value, if available.  No work was done."

Any more ideas?
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 1

Author Comment

by:beercat2
ID: 7154317
Could this be an MDAC issue?
0
 
LVL 1

Author Comment

by:beercat2
ID: 7209222
Well, this was an MDAC issue.  If you create a DTS package on a machine with an older version of MDAC, it can't be run from a client machine with a newer version.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 7209242
Points refunded and placed in PAQ

Computer101
E-E Moderator
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now