Hi,

I have moved the DTS package from sql 2000 to 2005 successfully.Now I also created the DTS job in sql 2005 as it is in sql 2000.

1.In sql 2000:Job Step(Default...

Thanks Manu..its worked....

Could you advice me how to resolve this upgrade issue

Thanks

Here Iam not creating a new DTS package in sql 2005. Iam Moving the DTS package from sql 2000 to 2005. In this case, I think the job will not...

thanks Brain,

I just copy the output script generated by sp_help_revlogin in sql 2000 and ran it in sql 2005, which is in different domain and the script ran succesfully and...

Thanks Brain,

As you are saying I should have atleast one sp_grantlogin as we have one windows login. But clearly Iam not getting sp_grantlogin statement in output script generated by sp_help_revlogin.

Here...

I do not have sp_grant logins statement in the out put script generated by sp_help_revlogin. Is this because of I having all logins as sql server authentication ? I just...

NO, sql 2000 is NOT clustered. For the upgrade we are going for cluster.

Hi,

Iam transfering logins from sql 2000 to 2005.Sql 2000 and sql 2005 are in different domains.

So Iam using the procedure exec sp_help_revlogin_2000_to_2005 @login_name=NULL, @include_db=1, @include_role=1

GO ...

Please clarify me which one of the following I need to do

1.

In sql server 2000 in Data Transfer Services->Local Packages->ABC(dts package name in the right pane)->right click the package->all...

Thanks Greg,

I have a dts package in sql server 2000 in Data Transfer Services->Local Packages->ABC(dts package name in the right pane)

From here How can I export to file system? If...

I do not want to make them as ssis packages. I just want to run those dts packages in sql server 2005. Inorder to acheive this what should I do?

If...

thank you..This drive also has data files along with bakups. Iam seeing this error only on Weekend. Every weekend we scheduled the INTIGRITY and OPTIMIZATIONS jobs which are scheduled...

Could you give me some more information on this backup faild issue..

what are the things I need to look for drive issues

thanks

What is the meaning of IO failure? where can I check for the drive issues?

Its production box..plz help me...

and I checked in the disk management all the drives are...