I'm copying and paste data flow in different package but on the same version of sql server 2008

Thanks, good to know, and feel better now to copy and paste tasks.

Thanks.

My new and exiting package all have the same connections with the same name.

But maybe the ID are different, does it matter?

I read the article http://denglishbi.wordpress.com/2011/03/25/ssis-package-copypaste-new-guid-id-fix/

It seems it gets more...

Thanks a lot.

But the solution the link points to include a visual basic project that pulls column name, it cannot be opened in BIDs, and I don't have a full...

I did see some event error logs after it is fixed.

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\Tools\VDT\DataProjects.dll . Error code = 0x8007000b

.NET...

No any updates and patches installed between.

Thanks for the nice article I will bookmark it for my favourite.

One question about the below statement,

Because of this behaviour, when a database is in full recovery model and...

Anything can be done on the report server that solves this problem instead of doing it on each client machine?

We are using sql server 2005 sp2

Thanks

Thanks,

I did check the maintence plan history, see the last lines in my original post, there is not a record for today's run in the history, the last run was...

Thanks, and it's good to know reporttempdb needs to be backed up.

Yes, it seems sql server thinks it as user dbs.

In maintenance plan if I choose to backup system db, it will not include the two databases, vise versa if I...

So in the result of the above script, does it mean the tables in truncate statement mean they don't have forign key constraint, and the tables in delete statement are...

Thanks, the link is not working now, but I will check back later on it.

Thanks, it's good information, and it's helpful to know this is rarely used, and the other favoribale option of doing that.

Still cannot get it.Any documentation online about the syntax?

I know CTE, but this seems not it.