Thanks for the clarification!

That helped. The full error is :

An error has occurred during report processing.

Query execution failed for data set 'dataset'.

Must declare the scalar variable "@GroupNumber".

I did...

This error is through the report manager.

I cannot restart the services now, since people are using it currently. Will have to do it at a scheduled time if there...

I am not sure what you mean by run the report on the server - do you mean using visual studio?

Also, I am assuming the services were restarted since...

Yes,

Here is the exact copied error:

An error has occurred during report processing.

Query execution failed for data set 'dataset'.

For more information about this error navigate to the report server on the...

Thanks much!

Not to sound paranoid, my original question was especially referring to the availabilty of the default sever availability DURING the upgrade of the named instance. I believe you...

We have run the upgrade Advisor and working with the vendor that provides the application to resolve any issues that need to be addressed.

One more question - this box also...

I thought so too. So when the document says that ''If you received a SQL Server 2005 hotfix after January 15, 2007, that hotfix might not be included in...

Thank you all for you input.

KR

-- It could be a generic error appearing because of something else with DTS. I know that any script tasks will cause a warning.

Since there are no dts packages...

Technically family + depcode should not create duplicates - i.e. all children are not marked with 1.

However due to bad data entry there could be two spouses, so...

Actually, it does not have to be in sql, but it has to be something that is automated, not what a user would need to do. Could you build...

Thanks to all for you valuable input. I will incorporate the above code (s) in my new design and will write back when I have been able to test.

KR

I would love to do it in the proposed design of doing it in separate job steps or through separate jobs. What I am having trouble is how I...

Both the above comments are very good points.

The reason for the continuous process design was that after detecting the flag(s) the migration tools can set, there is another...

I will not be able to control the entire process through SSIS. The migration tool cannot be controlled through SSIS. So given that I have to have a...