Have a look at the following and see fi they are of any help...

http://blogs.msdn.com/mattm/archive/2008/03/03/connecting-to-mysql-from-ssis.aspx

http://blogs.msdn.com/mattm/archive/2009/01/07/writing-to-a-mysql-database-from-ssis.aspx

http://blogs.msdn.com/mattm/archive/2009/03/02/how-do-i-do-update-and-delete-if-i-don-t-have-an-oledb-provider.aspx

-Luke.

Alvin Ramard (6/10/2009)

I was going to make a comment to you Gail about crystal balls...

Glad to have helped, I did just take a second look at my SQL syntax and realized I never specified more than 1 database, but hopefully it got you moving...

Glad you got it sorted.

Cheers,

-Luke.

Perhaps you missed the part where the OP mentioned

There is 1 table for each of the files. Each file contains a complete set of data and can be used...

ok, since you need to use it in a dataset (which I'm assuming because your sample code only seemed to get the userID for presentation or some such, which you...

If you find a different way please post back but that's the only way I can think of.

I've seen numerous discussions about how to remove a procedure, table, view etc...

Again it all depends on what the user group will be using this for, but along with the not every connection = a CAL bit, think about how the front...

Not sure if it's the same in 08, but in SSRS 05 you can use the UserID from the Globals collection as an expression in pretty much any object.

-Luke.

Depending on how many tables you need to change, you could use replace and just replace all 'a' with 'o' etc, etc.... or you could take a look at red...

Just realized I never actually gave you the answer... Again I'm not sure why you'd want to set it as low as 20, but in SSMS it's in the...

I suppose my biggest question would be why you'd want to... Granted this is coming from someone used to dealing with a poorly written vb6 app, but at any point...

You could take a trace and take a look at the queries based on that. Gail covers setting up a trace and combing through the results in her series...

I would create a view in one of your databases and use that to consolidate all of your data into one logical place, then query that view from your reporting...

No Problem, glad you got it sorted.

-Luke.