We are in the process of installing a new Server which has SQL 2000 on it. I transferred everything over from a SQL 7.0 server including the DTS packages. I am in the process of updating my DTS packages. I have to go in and change the connections to point to the new server. THe first package worked fine. I've gone into a bunch of other and I am getting the following error:
Error Description: unspecified error
[IBM] Client Access Express ODBC Driver (32 Bit) Invalid Argument Value
The ODBC connection is set up properly. It using same one that the package that worked is using.
I can change the server connection fine. But if I click on the tranformation and properties thats when I get this error.
We are using client access to transfer data from our as/400 to the sql server
any ideas?
Stacy
Error Description: unspecified error
[IBM] Client Access Express ODBC Driver (32 Bit) Invalid Argument Value
The ODBC connection is set up properly. It using same one that the package that worked is using.
I can change the server connection fine. But if I click on the tranformation and properties thats when I get this error.
We are using client access to transfer data from our as/400 to the sql server
any ideas?
Stacy