Trying to export from SQL table to txt file with dynamic property for txt file name, and using some global variables for defining criteria in source query.
There is also some ActiveX VB script to pass global variable to dynamic property.
When running, package fails on Transform Data Task returning following error message:
"Provider generated code execution exception: EXCEPTION_ACCESS_VIOLATION".
What is that?
"Execute on main package thread" is ON for all the workflows.
We had SP3 on SQL 2000. We installed SP4, but it didn't change anything.
Many thanx for whoever has some clue ...
There is also some ActiveX VB script to pass global variable to dynamic property.
When running, package fails on Transform Data Task returning following error message:
"Provider generated code execution exception: EXCEPTION_ACCESS_VIOLATION".
What is that?
"Execute on main package thread" is ON for all the workflows.
We had SP3 on SQL 2000. We installed SP4, but it didn't change anything.
Many thanx for whoever has some clue ...