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.

After looking up the syntax, I've found that you can only change a column datatype if all rows contain nulls in the column.

Looks like you're stuck recreating and...

I think what you're missing is that you're working with a table in an Oracle database and SQLBill is talking about Transact-SQL syntax.

The Oracle syntax for changing a...

Check out this article at SQLDTS.COM.

[http://www.sqldts.com/?234]

The IRS often requires C2 auditing of databases before sharing their tax data with state agencies. They're pretty particular about knowing who sees their data.

The package id is stored in the sysdtspackages table in MSDB. You can query the table to get the package name. I'm not sure how encryption of the...

If you use the wizard and choose the "Delete rows" option it'll use DELETE. To use TRUNCATE, you'd have to add an Execute SQL Task to the package in...

Yes, although it's fairly well commented inside the SP.

Try the sp_reassign_dtspackageowner stored procedure in msdb. You must be the current package owner or a member of the sysadmin server role to run it. I haven't had...

In the DTS wizard, select "Other" for your data source and create a new DSN using a Sybase ODBC driver (assuming you have one).