Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS and Invalid argument value error

Status
Not open for further replies.

swoodring

Programmer
Dec 7, 2000
114
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top