Ok, I will drop and recreate the index for either case that huge data insert as well as BLOB containing tables.

Jeff Moden (1/2/2014)

---

You can rebuild indexes that contain BLOB data...

Yeah...Drop and reinserting the data and create index after that would be good....but if we already have million of rows into the table, I don't think we must drop and...

Why are we not able to rebuild indexes having BLOB data? do we need to drop and recreate in alternate?

Thank You Ed, I am rebuilding and reorgranizing all my indexes to reduce the fragmentation and to increase the page space.

thanks a lot for guiding me in this....

Thank you Grant and Kurt...

I will check on the fragementation. I had no idea when i was asking this question. Now i get an idea on what basis the indexes...

Thank you ptebraak....I will check this one

I have been using NOT IN operator in many places but i had not known this problem with NULL value. Really i feel myself embarrased.

Wonder full question. i should...

Hi Paul,

This is really great. I could use this procedure. It would save me lot of time. Thank you for your wonder full work...

staudacher (11/13/2013)

---

In my Parent/Child configuration i had trouble with "each child package and i selected the connectionmanager property's connection string" and changed it to "link the StringParentVariable to the StringChildVariable...

staudacher (11/13/2013)

---

Okay, my first attempting is right.

In the Parentpackage you have the Variable ConnectionString.

Make the same Variable in each ChildPackage

Then in the CildPackages, instead to point to XML, choose ParentPackageVariabel,...

staudacher (11/13/2013)

---

I think i missunderstood you, sorry.

You will change the connection path from childtask.

In the properties from ExecutionTask there is "Expression" where you can change the Connection with Expression builder...

All the 10 packages will be having the same connection string..so is it possible to pass one variable which will affect all the package from execute package component task?

Could you please explain me? you mean selecting Parent package variable in configuration files?

I was also having the same situation when i tried to update with OLED command component. And then after some days, i went with option 4 which gave me a...