I have read the book up to Chapter 15. While I'm trying to execute the DTS package, I'm getting an error in step 2. It succeeds in performing step 1 - creating the database. At step 2 its giving me an error that says: Invalid OLEVERB structure. And 'SQL Server does not exist or access denied.'

Well, if its got to do with connectivity to SQL Server, how can it succeed in executing step 1?

Please help.

What does step 2 do? Don't have the book.

Step 2 transfers a few SQL Server objects like triggers, sprocs, etc. to the newly created database.

Do any of these objects have special features, such as creating objects using sp_OaCreate? If so, do those objects exist on the other SQL Server?

Brian

Hi:

It now works. I had not specified SQL Server authentication in Step 2 for the Destination. Now that I have specified SQL Server authentication, it works.

Thanks.