Unfortunatley,  there is not an option to do side-by-side upgrade on this server --- not enogh resources. 

Also,  I would like to know what caused this error since the account...

Thanks Markus, that is a start

KR

Maybe I missing it, but that just gives me the requirements for installing and running SQL Server 2005.  I read that if you want to be able to run a...

The start up account is the same as it has always been.  However, the ssis uses the built in network service account.  I did not set this up, so I...

Hi,

Both of you have put me on the right track it seems like -  I did find the missing certification in the error log.  Here is the curious thing -...

No the ssis seems to be enabled and running.  I did not see an options specifically concerning maintenance plans

Thanks

KR

Thanks so much for this input.  I was just considering it this morning, so I am glad to have this.  I guess I might need to modify the process...

Thanks!

Well, that is what I will try then.

KR

Thank you!

I am looking for more the best method of going about doing such a process - I was thinking that maybe I have to create a new column of...

Well since it in in varchar format it may not be all in the same format but for most part it is in mm-dd-yy

Thanks

KR

Thanks all,

It was a permission issue, but for an error logging file within the dts package.  It was on a different directory, that someone had changed the permissions to.

KR

Thank you all for your replies.  I have been so busy,  I am sorry it took me so long to post a reply -  Yes, the permissions thing is my...

Yes, it runs fine when manually run on the server and it is doing everything it is supposed to.  I will turn on the logging and see what I get. 

Thanks

KR

I did not restart the service, however I did not script it and just clicked OK on the wizard and the database was created.  Somehow the script would not work. ...

Thanks to both of you for you input

KR