Thanks for you reply..

Well My package will have 9 data flow tasks with different sources and same destination.....

Can I use this way?

Do I need to remove TABLE LOCK check option?

Thanks..Lemme try this ..

I am loading from an OLE DB source to an OLE DB destination,

Now the thing is that Destination is Common to all dataflow tasks...and source is depending on the conditional...

thanks...

ssis package with conditions..

any help?

Thanks,,

but my package is not failing..in the middle.

..its completing and then i want tostart it from the middle...

it's just that at that time i wont run 3rd Data flow task...

well the condition is like this if @ recordcount >100

execute Pacake1

else execute Package 2

Is there any way i can use if else T-sql in ssis to runa package.

Is there no other way to do bulk insert

Can u brief me how to use it in such scenario..i know a litle bit settin lineage ID

Thanks

I cannot execute in transaction..

its like loading and cathing error and coming out..

I want to know how can i make sure tht if I start the same job again it...

Its very simple

Take OLE DB SRC first..

Then Take Lookup and take ur target table in that...map ID take name from target (change to name1)

Configure Errorputput sAY redirect row...OK

Now from Lookup...

Thanks Jack, It Works Fine Now...:)

When I did this Send mail task with Single Row from table in result set in the EXECUTE SQL TASK ..it worked fine but now I want to send mail...

Thanks Mukti..It Works Fine Now 🙂

Now, I modify the Send Mail Task to include an Expression which updates the "ToLine" property with the email address in the "rsDetails" variable.

Moreover, I am not hard-coding the...