Thanks for all your help.

Finally, i could able to resolve this issue by installing 32 bit SSIS component (selection x86 option during installation) on the web server

The point here is, i am getting the error whilc creating the object for application class. ie. before loading the package. I am not sure whether i will get issue...

How do we check the installaed version (which bit) SSIS

Yes we have installed the SSIS component indenpendely on the server.

Note : Same thing works fine if my web server os is 32 bit (Eg : Windows 2003 32 bit)

I have measured the memory consumption with the Task Manager, 'Performance' tab.

Exacly i dont know how to measure memory bottlenecks.

What i did was

1. executed an script (more complex) and it...

I am not exactly showing it in the screen.

I just selecting and moving to temp table and doing further processing. Sometime, i export it to a textfile.

Actually you are required to join the row number using Row_Number() function and not based on any other field

Insert of using cursor, you can use the temp table and while loop

Insert all the records into a temp table and start a while loop update for no of temp...

Do casting

i,e <' Cast(date, varchar(25))

You can split the string by ' ' (single space) the you can take the second value for colour. similarly fo others

Create Procedure Testing

(

@Col int

)

AS

DECLARE @SQL VARCHAR(MAX)

DECLARE @grp1 VARCHAR(1000)

DECLARE @grp2 VARCHAR(1000)

//DECLARE @Col VARCHAR(10)

DECLARE @SELECTLIST VARCHAR(MAX)

//SET @Col= 2

SET @grp1= '[Tab1SalesHeader].No, [Tab1SalesLine].Description, [Tab1SalesLine].[Variant Code]'

SET @grp2= '[Tab1SalesHeader].No, [Tab1Sales Line].Description'

IF (@Col=1)

SET @SELECTLIST...

You have to use pivot table

i have done little modification

Create Procedure Testing

AS

DECLARE @SQL VARCHAR(MAX)

DECLARE @grp1 VARCHAR(1000)

DECLARE @grp2 VARCHAR(1000)

DECLARE @Col VARCHAR(10)

DECLARE @SELECTLIST VARCHAR(MAX)

SET @Col= 2

SET @grp1= '[Tab1SalesHeader].No, [Tab1SalesLine].Description, [Tab1SalesLine].[Variant Code]'

SET @grp2= '[Tab1SalesHeader].No, [Tab1Sales...

Your logic is correct. Can you post the exact error, so that we can help you

forums.asp.net

dotnetspider.com

dotnetcodeguide.blogspot.com