Good that you find the solution and thanks for posting it here.

I'd just want to add that one should always use the SQL command instead of the "table or view"...

Wouldn't the "easiest" solution be to just write a script task in .NET and read out that one single line?

Or am I missing something here?

The answer has been given in the following thread:

http://www.sqlservercentral.com/Forums/Topic1094054-148-1.aspx

The problem is that you are using numbers in your expression, but as result you give in some branches the empty string.

Strings and numbers aren't compatible, so either use NULL...

What are you using as a business key to uniquely identify a record?

To add a new dimension, you first populate the new dimension (obviously :-)) in the datawarehouse.

Then you add a new surrogate key field in the fact table and you change...

Great question, thanks!

If you've read the editorial, the question...

chetanb3 (4/15/2011)

---

Thanks.:-)..

I have another question, If I add the log provider as text file for master package..will that be ok.. I mean the file will contain log from child packages.....

That's because great minds think alike 😀

(Right now, I'm thinking of a combination of Friday and beer. You?)

A possible solution:

read the directory contents with a script task and store all the filenames in a table in the order that you want.

Then loop over the table with a...

What destination component did you use exactly?

Is it a problem that the table is locked?

You could use a script component to do this in your dataflow. Keep some variables in the script that check the conditions and update the sequence accordingly.

You can search the XML file for the variable.

(the .dtsx file is actually just XML)

On a sidenote:

it is a best practice to keep your packages small and modular. Just to...

Maybe this thread can help you:

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/18b7ad7d-48dc-4f3b-bdab-216f461b684a