Thanks

MIN MAX Memory settings, Just to make it clear.

I wasn't going to shrink the TEMPDB, I would never shrink a db in production especially a sys db.

I have queried the tables it seems that the 99% free reported...

SQL 2008 (10.0.2351)

Not R2

Ahh Might just work I have seen that done for the excel connection manager maybe I shouldn't be using XML Source and should use XML Task.

Thanks I'll try it on...

Do i need to use the XML tasks in SSIS or Flat file tasks?

The easiest way is to either set up a trigger to log delete actions or to set up SQL PROFILER to capture the activity on this table.

If you had a...

FOR 2008

USE 2008db;

GO

DBCC SHRINKFILE (<logical_logfilename>,5);

GO

For sql 2008

5- size you want to shrink to.

<logical_logfilename> run sp_helpdb.

USE database_name

GO

DBCC SHRINKFILE(2,1)

BACKUP LOG database_name WITH TRUNCATE_ONLY

...

Not for the destination table, has to be a table or view.

Almost there by following

http://www.packtpub.com/article/mysql-data-transfer-using-sql-server-integration-services-ssis

I can get the data to MYSQL but in have to create a table when creating the SSIS package. It doesn't recognise any of the...

Here you go.

http://www.johnsansom.com/performance-comparison-of-select-top-1-verses-max/

Is this available for SQL 2008 as I can't get the connection to work.

When I type in servername,username and password. the initial catalog is greyed out.

Using VS 2008.

Thanks I will try that, I do need all destination tables to be visable.

Again Thanks.

No I used the ODBC version. I just read that I need my source to also use ADO.Net.

http://dbperf.wordpress.com/2010/07/23/sql-server-integration-services-2008-ssis-and-mysql/

When I try to map the MYSQL table I have to...