You've hit the nail pretty much on the head.

We have two OLTP systems where from our SQL Server we export the data to the mainframe. The mainframe system has...

Have you looked into transactional replication?

There's also database mirroring that might help you.

You're saying you got it to work finally?

Yes, that is correct.

And yes, a customer can have more than one contract.

Lynn,

That's the problem. The OLTP doesn't have a Customers or Address table. All the customer info is stored in the OLTPContract table.

If I had separate tables in the...

I should mention, I don't keep AddressKey in the fact table since people can have multiple addresses. Mailing address, street address, etc.

Lynn,

Here are the create statements (sanitzed). The OLTP table does contain more columns but I'm only concerned with a small few.

Create Table OLTPContracts (ContractID int identity(1,1), FirstName varchar(25), LastName...

The easiest way to find errors is while you're in BIDS. When you execute a package in BIDS, it throws you into Debug Mode. When you're in Debug...

That one is pretty simple. You're trying to create something on the 2000 db that 2000 doesn't support. It could be a data type of a column...

Thanks, Guys.

One of my coworkers found the issue by pulling the fields into a XML datatype variable. It was a hidden character with some bizarre value that...

And that might be true, but the OP might have meant something different too. So, I'd like to hear from him regarding what he's trying to accomplish to make...

Ed,

Let me guess. Readers were asking him how much the resource cost. @=)

I'm glad I started this thread. I've been enjoying everyone's quotes. @=)

You don't need to make the login owner of the database in order to view the database. Not unless you're wanting that user to be able to alter database...

Practice, practice, practice with SSMS. Explore the GUI and figure out how to do everything. Right click every menu item, examine every available option, test every possible thing...