Thanks. How do I get around that?

I think you nailed it...Removing the ufds on the where clause speed up the process. Thanks a a lot for your help.

No it works if i close out SSM and re open it..But its annyoing. Any idea when the fix is going to be in place for this?

Yeah. Uninstalling Reporting services helped. Thanks!

I am in the middle of upgrading 2008 to R2. And I am gettting the following error message.

Use the Reporting Services Configuration tool to configure the database source name(DSN)...

We don't use Reporting Services. Just SSIS. My question is, when I migrate to R2, will the BIDS R2 automatically gets migrated as well? Or do I need to migrate...

Thanks. Once I install R2, do I need to upgrade my BIDS too? Or the older BIDS work? I have VS2008.

Thanks tfifield. The use of FOR XMl mentioned in the article did the trick. Is there any other way by just using the self join?

Given the table as below

Col1Col2Col3

ABABC

ABCDE

ABEFG

I need to be able to display only one row as below

A B ABC;CDE;EFG

Can somebody help?

I decided to first install R2 on test instead of aiming directly at production. Test server is bit different. Its running SQL SERVER 2008 SP2 on Windows 7 SP 1....

One thing I did find though is there is a batch process to zip the files that runs around that time that usually takes around 20 mins...Would this be causing...

SQL server...So do i need to restore msdb database? Can I restore this msdb into test server and retrieve my old package from there? But the test server will also...

Yes I have done all that. Seems like you need to grab that variable through Expression and use SQL command from Variable in Data Flow task. But I would like...

Did you get this resolved? If you don't mind, would you please post what you did to fix it?

Thanks for all of your help. My existing query actually worked. All I had to do was put the default value for the variable to get it working.