Conditional Split is way to go here. It is SSIS's CASE statement.

Timothy is correct. Furthermore, variables of type object must be mapped to a collection or recordset. You would typically do this inside the packge by an ExecuteSQL task.

How 'bout you take a stab at it first, then post your code so we can help you? BTW, please include example data and your expected results.

Joe, to be honest, it will be difficult for anyone to help you based off of what you posted. We don't have any of those tables, or any data...

gyessql is absolutly correct. Thanks for catching my mistake. You cannot reference a table outside of the SQL statement. gyessql's solution will work, and so would something...

Gail and Colin have you going down the right path. I'd continue to focus on the I/Os at the SAN level. You say that your DB instance has...

I would recommend following Robert's advice. Here's some code to work with. You'll have to add to the select list to get all of your columns, but this...

I see a few things here that would concern me. First off, it looks like you are using a sequence table to manage your PKs, correct? This is...

Robert klimes (1/15/2009)

bocleared cleareddate ctcleared cleareddate totalcleared cleareddate

2 1/2/2009 ...

You're IF EXISTS...SELECT statement is missing the alias name for the table.

Try this:

if (EXISTS(select name from tablename table2 where name = table2.name and date = table2.date))

begin

Or this:

if (EXISTS(select...

Times of economic downturns represent great times for opportunty for those who are looking for it. While the masses are busy pulling all of thier limbs into their shells,...

It may just be your Express version of Management Studios. We had a developer here who was having problems seeing the service broker and it was because he had...

Great. Thanks for the feedback.

That should definately work, but just in case, here's a couple more alternatives:

1. Shut down the service from another computer, then copy files.

OR

2. Most laptops allow you to redirect the...

Yep. Many of the interworkings of SQL Server are cursors under the hood. This just beats writing one and works fine for admin tasks.