I recently got a new SQL Server. I got everthing setup ok, I think, but when I run this complicated DTS task I'm getting and error "SQL Server does not exist or access denied".
This DTS has multiple steps and reads a number files from our iSeries server and writes to the SQL server. The DTS worked perfectly (and still does) on the "old" SQL server.
One step however, reads 142,000 records, and gives the above error on exactly 245 records. After much analyzing, I realize that the error occurs every 3,950 records, list 6 records in sequence in error, then is ok for another 3950 records. Each record is about 100 bytes. This pattern repeats thru the entire file.
I have another file that has almost 12 million records, and it never records an error. I've checked all the OBDC settings, and everthing appears identical.
Environment:
"old" server: SQL 2k Standard running under Windows 2000 Server.
"new" server: SQL 2k Enterprise SP3a running under WIndows 2003.
It sounds like a buffer/blocking/timing issue. Any idea what i should be looking for?
This DTS has multiple steps and reads a number files from our iSeries server and writes to the SQL server. The DTS worked perfectly (and still does) on the "old" SQL server.
One step however, reads 142,000 records, and gives the above error on exactly 245 records. After much analyzing, I realize that the error occurs every 3,950 records, list 6 records in sequence in error, then is ok for another 3950 records. Each record is about 100 bytes. This pattern repeats thru the entire file.
I have another file that has almost 12 million records, and it never records an error. I've checked all the OBDC settings, and everthing appears identical.
Environment:
"old" server: SQL 2k Standard running under Windows 2000 Server.
"new" server: SQL 2k Enterprise SP3a running under WIndows 2003.
It sounds like a buffer/blocking/timing issue. Any idea what i should be looking for?