Yeah that is what I have been doing since I couldn't get around this migration wizard error, but no I have found myself with another problem which is using temporary...

yeah that is what I have trying to do but I still can't get around an error I am getting at the moment of generating my sql command.

I am...

so maybe this is a mistery in SSIS? :w00t: lol suggestions???

Hi there 😀 have you checked this post?

http://www.sqlservercentral.com/Forums/Topic417928-148-1.aspx

well hope that's helpfull in some way. 😀

hey what about SQL Native Client??? does changing the compatibiliy level affect this in any way? Thanks

I am sorry but my English is not very good anymore :hehe: but you just keep guessing what I am trying to say lol Thanks again for answering so soon....

So I would have to upgrade my clients applications connections right? in order to make them compatible with sql server 2005?

Thanks for that quick answer Cliff. But I have one last question to fire 😀

What about the clients?Does changing the compatibility level affect the clients in terms of network connections?...

Cliff Jones (4/29/2008)

Actually, that is what we...

I have wandering around the net for some answers for a while now but I still have the same questions 🙁 what about performance and things like that? does...

About the upgrade advisor, it's done 😎 and all the implementations it asks for. But there are some warnings like the networks connections that aren't supported anymore by 2k5 and...

Hi everyone, so there is not a known answer for this topic yet :crying:

Do you guys think if Microsoft has an answer for this?

I have to migrate a database...

Hi everyone, I know this is not really about the original post but I hope you guys can help me out. I have been searching the web in order to...