A couple of quick querions:

1. Are you using the for loop container or coding your own loop in a script task?

2. What is the reason for the 2000 row batches,...

Is that the only other place you'll be using the IDList? Maybe it would help if you could give a brief description of the package's purpose and the logic...

You'll still need to change the data type to 'object'. Try that out and let us know if you get past your error.

Any time you are storing a recordset (even if its a single row) into a package variable, you must define it as an 'object' data type, not string. Change...

You're quick Barry. I checked for other responses just before clicking the Post Reply button.

The GO statement is used by osql and isql to logically break a SQL script into batches that it can send to the SQL Server. Each chunk of code...

I've got to roll out for the day, but I'm real curious as to what some of the other heavy hitters are going to say.

You mentioned thinking bigger....

Thats better. Thanks Sam. So what you really want to display is any student who has had an F in any class?

I'm taking off for the...

OK, then you have to rely on the setup table maintaining your data integrity? Why add another layer? If you were going to go this route, why not...

What does 'at least an F' mean?

You should not need a cursor to run a delete. What's wrong with a simple SP that does the following?

BEGIN TRANSACTION

DELETE c1

FROM Child1 c1

...

First off, keep in mind that NOLOCK is equivelant to READ UNCOMMITTED isolation so you are reading dirty data. There's a bunch of problems that can come from this....

This should help: http://www.sqlservercentral.com/articles/Test+Data/61572/

So do you have a question? A problem?

You need a BEGIN/END around the statements between your IF and ELSE.