> > > the only difference that i can see between the two > > > architectures is that SP3 is on the SQL box that > > > doesn't work, and vanilla SQL 7 is on the one that > > > does. > > > > You might want to make sure both boxes have the same > > version of MDAC. You can test this by running the MDAC > > Component Checker, available at http://www.microsoft.com/data/. > > it's the exact same. down to the tertiary version number.
Then, you must sacrifice a chicken. Sorry I don't have a better answer. What happens if you run the DTS package via dtsrun.exe, or through an sp? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
