taco

dbowlin (7/9/2010)

---

Steve Jones - Editor (7/9/2010)

---

dbowlin (7/9/2010)

---

Like most of you I probably won't stop 'till I drop. Even then the bills may keep coming.

I am not sure whether to...

Is there an update on your progress that you can give us?

DITTO....I've been back home less than...

babyback

hunch

Using my example from before:

DECLARE @Vendors TABLE (xid varchar(2), name varchar(20), internal bit)

INSERT INTO @Vendors

SELECT 'V1', 'Corporate University', 1 UNION ALL

SELECT 'V2', 'Learning Provider', 0

DECLARE @Companies TABLE (xid...

Freedom

I agree with Paul, Steve and the rest. Partitioning is not the right tool for this job unless your users table has hundreds of millions of rows in it....

DECLARE @Orders TABLE (OrderID int, ClientID int)

INSERT INTO @Orders

SELECT 1, 234 UNION ALL

SELECT 2, 234 UNION ALL

SELECT 3, 234 UNION ALL

SELECT 4, 200

DECLARE @Items TABLE (ItemID int, OrderID int)

INSERT INTO...

I would recommend identifying the cause of the deadlocks and resolving it. There is most likely something inside the application code that is causing the deadlocks.

There is...

In the meantime, consider this example:

DECLARE @Vendors TABLE (xid varchar(2), name varchar(20), internal bit)

INSERT INTO @Vendors

SELECT 'V1', 'Corporate University', 1 UNION ALL

SELECT 'V2', 'Learning Provider', 0

DECLARE @Companies TABLE (xid...

Can you provide us with the DDL for the tables involved along with some sample data? See the link in my signature line for posting sample data.

dg227 (6/30/2010)

---

Good point: for any command line-type tasks, I always work with them outside of SSIS to nail down the exact syntax that I need (including the relevant flags/switches) to...

dg227 is exactly correct in that you'll want to use variables to dynamically configure a task.

With that said, you still need to get the syntax down for your decrypt command....