How about this?

select 'ALTER TABLE ' + cast(table_name as char(30)) + 'DROP CONSTRAINT '

+ cast(constraint_name as char(50)) + char(13) + 'go' +...

You should either use a Data Driven Query task with an insert query or an Execute SQL task with an insert query.

The insert query should look something like,

/*Insert...

You'll need to add an Execute SQL Task to your DTS package that disables or drops the FK constraints i.e. ALTER TABLE with CHECK/NOCHECK CONSTRAINT. Here's a script to...

Do you want to use the VB front end and eliminate Access altogether (sounds like option #3)? If so, I recommend using DTS to move the database from Access...

Once again, the typo (articleid) in the email is corrected (article_id) on the web page. This has happened enough times that I always go to the web page to...

Oh man, I feel for you. Some of my longest days have been spent trying to configure Oracle.

Hope the book helps!

sp_cycle_errorlog will close the current error log and open a new one without restarting SQL Server. See "sp_cycle_errorlog" in BOL.

Greg

I don't know of any utility that can translate the export file into SQL Server. As far as I know, an export file can only be read by the...

Syslogins is a view in the Master database that selects from sysxlogins table. Curiously, BOL refers to syslogins as a system table.

Yeah, the online courses should get you started. Some good books to consider are "Oracle DBA Survival Guide" (SAMS), "Oracle DBA Handbook" (Oracle Press), and "Oracle Backup & Recovery...

We've never had a problem restoring a MSSQL7 backup to a MSSQL2K database. It's one of the supported methods for upgrading from v7.0 to v2000. See Knowledge Base...

I started working with SQL Server after being an Oracle DBA for a couple of years. My Oracle responsibilities have declined over the past 3 years as our databases...

Have you enabled logging to msdb in the package? That's always allowed me to view details of a package error.

Check Visible Analyst from Visible Systems.

http://www.visible.com/

ALTER COLUMN is not allowed in an ALTER TABLE statement if compatibility level is 65 or lower. See the same page in BOL referenced by Gary.