Here is another one....

Hope this helps 😉

You need to break the comma separated string to a temp table and then you need to group by to take the count.

You can use following function for the same:...

Yes. you are correct. You need to use the OLEDB command to update the status code.

You can use "Multicast" component to give same SELECT statement source to UPDATE statements.

Using...

Try using "derived column" to convert the data

Add a "derived column" component after OLEDB source and

use (DT_NUMERIC,4,2) in expression for derived column.

Hope this helps 🙂

You can use this procedure to get last day.

The catch in this is you have to pass 1st day in start and end date.

else need to modify proc to calculate...

There is no way you can start from a particular step.

Though you may try to achieve this by using variable, expressions, script ask.

There is no way you can start from...

For packages those are failing, check "ProtectionLevel" property

Also Check connection pooling for SQL server. I guess The connection is not getting realeased after execution of each package.

Can you post the error message as well ?

From your post, it seems that you are doing an incremental load from excel to database.

What I suggest is cerate one lookup table and just stored the last successful load...

Hi

Please go to this link.. this may be helpful for you.

[/url]

--:)

This is very interesting solution , but works only if you have rights for Enterprise manager.

Follow these steps:

1) Right click on desired...