I think you misunderstand FILESTREAM.. All you stored was the text 'C:\test.doc' it stores the file in IT's location and it doesn't keep the same name, it ends up...

It is inconvenient and if you have SQL 2005 and 2008 SSIS servers you have to use the SSMS that is for that version.. It is rough..

CEWII

I think you might have a problem. I'm am 99% sure that the 2008 SSMS will not open them. I tried this recently. It didn't give me...

ToddJames (10/5/2009)

---

We do use Excel from source and destination. We also do script SQL tasks. It is possible going from SQL 2005 32 bit to sql 2008 64...

I believe the answer to your question is yes, but....

Do you use the Excel source or destination? If so then that package will have to be run with the...

I agree, there aren't a lot of reasons to do this. I also think that clustering raises even more questions as to why..

CEWII

Could you clarify what you are asking and please provide a couple more examples. I am really unclear what you are looking for..

CEWII

That is a yes/no question.

Yes you can deal with SQL 2005 Instances for the database engine. I do it everyday.

But you cannot connect to a SSIS 2005 server, see:...

I have experienced this as well, I was often getting no matches when I could see the match in the table.. It wasn't till I forced a trim in...

You may be right..

CEWII

I thought it went back further than that.. But I had also read that sp_password is not masked in SQL 2005/2008 anymore but CREATE LOGIN and ALTER LOGIN are..

Since...

Ok, you had me worried. Great..

CEWII

I don't know Lynn, I just really try not to use dynamic SQL is there is another reasonable alternative. It certainly has its place..

CEWII

You don't use "xp_smtp_sendmail" on SQL 2005 or 2008 do you?

CEWII

I would tend to suggest many of the source control packages to handle concurrency. Is that your problem?

CEWII