error in transfer sql task

I am trying to transfer tables from a 2000 database to a 2005 database. I selected only the tables I wanted and when executing the task I get:

Error: 0xC002F363 at Copy Tables, Transfer Sql Server Objects Task: Table "XXX" does not exist at the source.
Task failed: Copy Tables

I have the correct permisions on both (they are both dbo.) and I can create DataFlow tasks for each individual table, however there are about 50-75 tables I need to copy. I tried recreating the package with no luck. Any ideas?

Thanks,
Abe

Try using "Windows Authentication" instead of "SQL Server Authentication" at the destination. I remember seeing a bug (which has been fixed and will be made available in the next SP release).|||I am using windows authentication in the destiantion. I don't have a choice other than using sql authetication at the source though.|||Sorry. The information I gave was not correct.

I did not read your post carefully. I was referring to a different bug related to transfer of objects between two SQL Server 2005 servers.

As far as your problem is concerned, it has been identified as a bug and being handled.

Hopefully the fix will be available soon.

Error in SSRS Expressions

I am having an expression which is supposed to give me the values selected in a multivalued input parameter. I have tried following options however everytime it gives me error. Could someone let me know what might be the issue here.

1. Expression: =Parameters!i_Category.Label

Output: The Value expression used in textbox ‘textbox47’ returned a data type that is not valid.

2. Expression: =Parameters!i_Category.Label.ToString()

Output: System.Object[]

3. Expression: =CStr(Parameters!i_Category.Label)

Output: Error: Conversion from type 'String()' to type 'String' is not valid.

Take a look at this link for more information about parameters and working with multi-valued parameters.

http://msdn2.microsoft.com/en-us/library/aa337292.aspx|||Thanks Ian. It helped me a lot.