Thanks man this works. Recursive cte helped. And my problem is solved in this case.

Just out of anxiety a question, can't we use NTILE in such cases ?

Hi Techies any reply for this.

Hi, Thanks for the reply.

I already have a TRY - CATCH in place.

Presently my script is having 3 input table names and there are 3 filter strings.

There could be error...

Hi Friends,

Any thoughts on this !!

Thanks it worked

Thanks a lot for the reply.

In the above e.g 1 and 2 represent column no (sequence).

I have seen in queries people using 0.1 and 0.01 in case when

e.g

order...

Team,

I have found a solution for the same. I installed Microsoft ReportViewer 2010 Redistributable Setup on target machine and it solved the problem for me.

Thanks,

CAn you put some light on that / Any link to that code will also prove helpfull.

I have been through this link before didn't understand the code here

http://stackoverflow.com/questions/673808/adding-new-output-column-to-custom-data-flow-component-ssis

Thanks,

Can you please put some light on that / any link to that code will be helpfull.

I have been through this link before, didn't understand what in it

http://stackoverflow.com/questions/673808/adding-new-output-column-to-custom-data-flow-component-ssis

Thanks

The first method is very much in my mind .

But is there any means the second method can be addressed that's the question.

Thanks

Hi,

I will explain from the start. I have more than 10 tables having columns ranging from 85 to 150. I need to load them in 10 target tables.

First method is...

Thanks for the comment

Since all columns in input are pushed to the Output any method that will create the output columns dynamically.

I donot want table A to contain all of the values in table B after the package has run.

If I consider A as source table and look up on...

Thanks for your instant reply.

In the first query where I have used sp_xml_removedocument can u please let me know what is wrong .

Thanks

Team,

First of all, thanks for replying to my post.

But sorry to say, I didnot get ur answer.

U want me to merge these resultset using an union all, but in my...