Thanks a lot.As of now it is working fine.Its just taking 2min for executing 2lakhs records.

Thank you very much for your help.

Regards

Srinivas

Thanks a lot.We have changed the tally table query which is going inside twice.

As of now it is working fine.Its just taking 2min for executing 2lakhs records.

Thank you very much...

Hi

The below query is working fine but it is taking more time to execute 2-3lakhs records per day

It has taken 2:30min in my production server today.Please check the below query.I...

Hi

Thank you very much.The above query is working fine.

Now the problem it is taking more time to execute 2lakhs of records per day.

For 60rows = 6sec

...

HI

Thanks for your help

Still facing the same problem.Actually the original query is mentioned below.

changed the column MenuName as NodeTraversed.

First Iam going to mentioned below function which splits comma...

Hi

Thanks for your help.

This is working fine if the records are less

And not working if you have lakhs of records.

So in my production server it is not working.

It is...

Hi

I Have a very critical issue in Comma separated values using XML Path

I have table "MENU" storing data as mentioned below

MENU Table:

-----------------

CallStartDateTime MenuNames

2014-09-18...

There is a datasource to connect source database.And in oledb destination control in SSIS having the option preview,once it is clicked we will get top 200

rows ,will come to know...

Hi

Sorry for the late reply.I have multiple jobs schedulers which will all the schedulers for every 15minutes,so that data will be transferred from cache database to...