To clarify, “Backup & Restore” method means doing a full backup and restore it to SQL2005.

What if an OLTP database (300 GB) with a very tight down time? Is...

BTW, I do not see SQL2008 has much change. There is no modified date or version change history/log in msdb.dbo.sysssispackages.

Just found verbuild can be set manually during SSIS pkg development stage.

In MS Visio Studio, open the project, from solution explorer, click SSIS Packages, right click YourPkg.dtsxà Open, from the...

Do you know how much data (rows -->GB) to delete? Deletion needs 2 times of the data size for the log. If you delete 10 GB data, 20...

Yes, verbuild is the one. verid also helps. packagetype is useful too.

What is default client when packagetype = 0?

Thank you Gordon.

So if verbuild = 0 means no change after SSIS pkg is deployed? If it was modified/re-deployed, the verbuild will become to 1?

I have an urgent need...

Very tricky! I made a guess. Yes. Anything is possible.

Thank you Matt.

system table dbo.sysdtspackages90, Is createdate column for originally “created” date only? If any change/modify for SSIS package, does the column reflect the change respectively which means...

Is there a way to see when the SSIS package is modified? or any version history available from system table/view?

4 years experience can gain at least 6 figures in Montreal? Very attractive!

Right click...it works for one database and is a manual process. I need to get a script for all databases so I can automate/schedule it on a regular basis.

Good utility. But it seems for generating database objects not database itself. I need to generate script for all databases on an instance.

For example

Create database mydb1...

Really helps. Thank you very much!

Great info. Thank you.

I am looking for sending email with attachments/reports rather than email message. As per the article, “If you want to send mail with attachment ,...

May try these steps:

1. Select the duplicated records into a temporary table

Select * into mytable from yourtable where clause …

2. Delete both records (duplicated records) from yourtable

3. Insert 1...