If there is a clustered index on the table then DBCC CheckTable should not return an error for indexid 0, so I don't think there is a clustered index on...

I'm guessing you are migrating from the DTS world to SSIS. Let me assure you that you will like SSIS better. There are some annoyances, but it is,...

jluniya (9/5/2008)

---

In this particular example SSN can be treated as unique number so there is no need to join on all 5 columns. If you want to transfer this data...

Try it again as I just copied and pasted the link into my browser and there was your original post and a reply. Sounds like a browser issue? ...

I believe that INDEX ID 0 means the table is in a heap, no clustered index and is now in an inconsistent state. I would restore a backup to...

You can't edit a package in SSMS unless it is a Maintenance Plan and you have to do these under a DB Engine connection in the Maintenance Plan area.. ...

If you go to Report Manager (http://servername/reports is the default) you can download any report on the report server. You do this with these steps:

1. Go to report...

I would define it as a single field that has no meaning, is system generated, and exists mainly for maintaining relationships. For example, in the US a person would...

It should be saved to msdb on that server. In the Object Explorer in SSMS under the Connect Menu select Integration Services and then connect to the server you...

Unfortunately sp_depends and sysdepends are unreliable as SQL Server will allow you to create a stored procedure that references a non-existent table so the dependency is not created in sysdepends.

If you have defined the foreign key in the database and have not included any Cascade options then the database will not allow a delete that will break the relationship...

Really the best way to handle this is to return all the data you need in one dataset as it reduces round trips and makes working with the data in...

Brandie is right that you can't mix data types. I'd do this:

PROC_DT == "00000000" ? NULL(DT_STR, 8) : (SUBSTRING(PROC_DT,5,2) + "/"

+ SUBSTRING(PROC_DT,7,2) + "/" + SUBSTRING(PROC_DT,1,4))

The NULL(DT_STR) produces...

For the tables, and yes this is basically a wrapper around a cursor, you can use the undocumented sp_msforeachtable procedure. Something like this:

exec sp_msforeachtable @command1 = 'exec sp_changeobjectowner ''?"",...

None that I am aware. How are you planning on doing the migrate?