thank you very much for the response. I found the below post which gives details of how ssis sends data in multiple buffers. ProcessInput method is called once for each...

Not sure if the order of the inserts matter. Else the below would work:

DECLARE @a INT

SELECT @a=MAX(empid)+99 FROM dbo.employee

INSERT INTO dbo.employee(empid,name,city)

SELECT @a+ROW_NUMBER() OVER (ORDER...

I see a couple of issues here. variable User::date has to be used in expression as @date. there is no convert function at all.

I am not sure as to...

Please let me know if you need more information or if my question wasn't clear. Anyone pls reply.

Can anyone please try and let me know if you have the same...

Use the below code:

SELECT

ISNULL(x.y.value('Display[1]', 'VARCHAR(30)'),'') AS col1,

ISNULL(x.y.value('Display[2]', 'VARCHAR(30)'),'') AS col2,

ISNULL(x.y.value('Display[3]', 'VARCHAR(30)'),'') AS col2,

ISNULL(x.y.value('Display[4]', 'VARCHAR(30)'),'') AS col2,

ISNULL(x.y.value('Display[5]', 'VARCHAR(30)'),'') AS col2

FROM

(SELECT CAST('<aa><Display>'+REPLACE(DisplayName,'/','</Display><Display>')+'</Display></aa>' AS XML) as Display FROM TEMP#...

The errors were gone when I used ExecuteProcess task to execute the childpackages instead.

Thanks and Regards,

Praveena

The solution I provided would give the results.

1102

345

678

9

123

12

12

12

But rearranging them to something like below would give less number of rows within the results. I removed the second row and added...

ChrisM,

No two columns should have same value within a row. With the query you provided, below is the result set:

111

222

123

124

567

8910

3NULLNULL

First two rows have same values for all the columns.

Thank you...

Bob,

thank you for the reply. I need all the 19 values even if they are duplicated(count of rows in Table_2). Just rearranged in batches of 3, such that no two...

Thank you. I can store the credentials for the parent report using a datasource. But I want to pass the credentials down to the child report. I am using the...

sorry the correct sample file values are

flatfilesample.txt:

01-JAN-0001 02.30.32.001001 PM

01-JAN-0001 02.30.32.001001 PM

01-JAN-0001 02.30.32.001001 PM

01-JAN-0001 02.30.32.001001 PM

@lowell : The timestamp(6) expects a value in the format '01-JAN-0001 02.30.32.001001 PM'. I used the same format in the flat file source.

Below is the test data...

@phil:Thank you very much. It worked

@Phil: I typed ASCII 30 in the delimiter field and it actually used the string "ASCII 30" as the delimiter. I am sure thats not the right way as it...

sorry I wasn't clear on my question. I would like to use ASCII 31 and ASCII 30 as field and row separator in the flat file manager. Is there a...