You should have in elipsis in the expression property for a variable.

As far as the error, it is because your date variables are of date data types and you cannot...

If you drag the variable from the variables list in the expression builder, you can avoid these problems.

Variables in expressions are case sensitive. You need to capitalize the "U" in "User":

"sp_OracleInterface_InvoiceNoTemp '" + @[User::StartDate] + "','" + @[User::EndDate]

RE-reading my post, I may have sounded a bit harsh - sorry about that.

The point I was trying to make about the cube walls is that while this may not...

set @ID = @@identity;

This is your problem.

Look up @@identity in books online.

It will be empty unless you have just inserted into a table with an identity column.

It is there to...

I've had everything from private offices to working in basically an open fish-bowl with several other developers. I don't really care either way. I think any company making...

You could do this with a check constraint, but the best solution would be to create another table with the "T" and "P" values as the primary key - and...

Very true, if you have to judge a tool by the number of people that misuse it, Analysis Services must be a total failure as well.

I am always amazed at the number of people that have trouble with getting SSIS to insert new rows and update existing ones.

For small tables, the Slowly Changing Dimension transformation...

I agree - really bad idea.

Use an ALTER TABLE script or copy the data into another table. Don't try to do this manually in the system tables.

I would recommend you add an annotation to your project to note that you have used an expression. Nothing in the SSIS designer really helps you find them and...

The expression looks ok.

Hard-code a value into the SQL Statement (it will use this to figure out the meta-data) in the source component and remove the parameter information.

Rather than using a query with parameters (?), use an expression to build the query.

I am not sure which Sybase OLEDB driver you are using, but the couple I have...

Put a sequence container around the 4 tasks. Have the 4 tasks fail with their default settings. Set the sequence container ForceExecutionResult to success.

This should make the task...

You are in a SQL 2005 forum.

For SQL 2000 you have a couple of options that I can think of. It will depend heavily on what the web service...