I have a DTS package created. I have created a few global variables as well. I am trying to call a Stored Procedure from an ExecuteSQL Task, and I am trying to pass in a parameter. The parameter is decalred as a date and the procedure is expecting a date, but I get the following error:
"Need ro run the object to perform this operation. Provider generated code execution exception: EXCEPTION_ACCESS_VIOLATION". I have searched google and the MS website, and it all seems to center around Visual Basic, but I am not using ay ActiveX scripts at all. If i hardcode a date into the call to the procedure instead of using a parameter, it will work without issue. Thoughts?