Viewing 15 posts - 961 through 975 (of 3,232 total)
Yep, it makes sense. I'm not sure if that's how I'd design it, but it is what it is. My personal preference would be to have a Customers...
October 15, 2009 at 2:38 pm
Yes, and you are right that it sounds like that is already what is happening with meichner's existing Customer Address table. The Customer Address should only be related to...
October 15, 2009 at 2:08 pm
That's fair. I think we need more info then from the OP as to how the addresses are currently being related to other entities.
meichner,
Care to handle this? ...
October 15, 2009 at 1:59 pm
Ok, so the proper way to represent the many-to-many relationship between Customers and Addresses is to have the associative table CustomersAddresses. Agreed. But you do not want to...
October 15, 2009 at 1:37 pm
Using the CustomerAddress table is the correct way to go if you truely have a many-to-many relationship between Customers and Addresses, but using the CustomerAddressID to 'link' that value to...
October 15, 2009 at 1:25 pm
That, or setting the Error options in each of your Destination objects to ignore the error or redirect the error rows to another table.
October 15, 2009 at 1:03 pm
Each item inside a container will be part of the same transaction. If you want to allow one table's data to load if another table's load fails, they need...
October 15, 2009 at 1:01 pm
Nope. In your case, the Data Flow task is the lowest grain container available to you. You'll notice that while inside the Data Flow task, there are no...
October 15, 2009 at 12:51 pm
I would go with a combination of the above suggestions. First, design your packages with the appropriate transaction behavior to meet your needs. Then, use a lookup transformation...
October 15, 2009 at 12:49 pm
If all 10 data pumps are inside of the same Data Flow task, it will be an all or nothing load since everything inside of that Data Flow task will...
October 15, 2009 at 12:45 pm
Have you tried using the Transfer SQL Server Objects transformation?
October 15, 2009 at 12:37 pm
Agreed....we don't have enough info to help you here. How about posting the code that you are using to 'mark' the row as reserved. It looks to me...
October 15, 2009 at 12:35 pm
What are you trying to do here? I agree that such a simple statement as SELECT 1 should work here, but I fail to understand what your desired end...
October 15, 2009 at 12:30 pm
Select your Destination Flat File connection in the connection manager, press F4 to pull up the object properties, and use the Expressions feature to set the Connection String property of...
October 15, 2009 at 12:25 pm
For that value to be stored in the database as '00', it will need to be a char/varchar data type. I would question changing it through depending on what...
October 15, 2009 at 12:12 pm
Viewing 15 posts - 961 through 975 (of 3,232 total)