August 21, 2002 at 9:44 pm
I recently wrote a VB custom DTS task that zips up files. It works fine on my machine. It works fine on a users machine. It works fine on the test server. Unfortunately it doesn't work on the Production Server. The Icon can be copied onto the DTS work space but it wont open the Property window. It gives a message of "Cannot store property values in file or repository if they are empty, null, arrays, or objects". I have looked this error message up in Microsoft and it is error: DTSPackage_E_CannotPersistProperty.
As far as I can tell both test and production machines are running windows 2000 sp2 and sql server 2000 sp1. So I am at a loss to explain the situation. I believe this is known as dll hell and would be very grateful if a dll angel out there could rescue me from my predicament.
Thanks in advance
Niall
August 22, 2002 at 4:38 am
Break the DTS package into pieces and try it, each time adding a little more until you find exactly what causes the blow up. That is the best way to trouble shoot and pinpoint the problem.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply