Actually, I dont have any input in a way to be presented, Its just I want an approach to do this problem.

I can put it in steps like this:

> OLE...

I have used AppDev videos to learn SSIS.

You can either buy them or search for the video links in rapidshare.

I found the SSIS 2005 videos from AppDev better than the...

I think in the 1st step, we should use Data...

I tried a work around for this:

1) In the For Each Loop Variable Mappings map Index 0 to a string variable (user::filepathname)

Set Folder Path

Set Files: *.zip

2) With in the For...

I can answer this...

Configuration table can be any where, any data base. Connection to...

da-zero (6/22/2010)

---

tmitchelar (6/21/2010)

---

vineet1234 (6/18/2010)

---

5) This way we get the non-matching rows in the error out put. These are the new records coming in.

Among the matching rows we can use a...

Raunak Jhawar (6/21/2010)

---

Even better...I remeber there was an...

http://support.microsoft.com/kb/918760

Hope this link helps...

Let me know

TRY THIS:

ISNULL([var_a] == [var_b]) ? (ISNULL([var_a]) && ISNULL([var_b])) : [var_a] == [var_b]

LET ME KNOW IF IT WORKS

THNX

Hi ...

Let me try to explain the way our team had implemented this in one of my past projects:

In a data flow task:

1) OLEDB Source had the source query (Example...

The best way to use Execute SQL task is to have the SQL statement as an expression.

Whatever parameters you want to pass should be declared as user variables.

In the execute...

Parameters can be passed to the where clause if the entire query is stored in a string variable.

If there are 2 parameters to be passed, then create 3 variables.

One variable...

Keep the child package out of 1st transaction...

Child package should be called using the Precedence Constraint = Success..

Try putting the tasks in a sequence container.

Sequence containers are meant to handle transactions

Yes you are right

I was missing the AND in my join...

working fine now.

Thanks