Like this?

DROP TABLE IF EXISTS #temp_Samples;

CREATE TABLE #temp_Samples
(
    Guid UNIQUEIDENTIFIER NOT NULL
   ,LastDate DATETIME NOT NULL
);

INSERT #temp_Samples
VALUES
('D87BF755-44C2-415A-A241-1512409F52E3', '2019-07-10 20:09:32.000')
,('929DF755-44C2-415A-A241-1512409F52E3', '2019-09-17 20:19:01.000')
,('42A2F755-44C2-415A-A241-1512409F52E3', '2019-09-17...

• This reply was modified 7 years ago by Phil Parkin. Reason: Changed MaxDate to MinDate ... made a bit more sense

Can you provide sample DDL and data, please? In the form of INSERT statements.

Advise what, exactly?

One option would be to write them out as 4 separate files then merge them or write them out with different targets to the same file and the first...

Can you provide sample DDL and data, please? In the form of INSERT statements.

Try this

DROP TABLE IF EXISTS #data;

CREATE TABLE #data
(
    Ref INT
   ,Design VARCHAR(200)
);

INSERT #data
(
    Ref
   ,Design
)
VALUES
(2566000, 'Sandália BEBE...

Here is a start for you. I don't have time to complete part 2 right now.

DROP TABLE IF EXISTS #data;

CREATE TABLE #data
(
    Ref INT
...

I don't think...

Are you using an OLEDB destination in your data flow?

What are the values of 'Rows Per Batch' and 'Maximum Insert Commit Size'?

What is the structure of your SSIS package?

• This reply was modified 7 years ago by Phil Parkin.

I don't understand this part:

If its Thursday then show Friday, Saturday and Sunday of next week.

How can all three days be 'shown' simultaneously?

Based on what you posted, it really isn't.

Or if it is, where did you get your syntax from?

Without knowing what the proc or code do, how do you expect us to help you with this?

1. Create the login:

CREATE LOGIN [domain\ntuser] FROM WINDOWS

2. Add the login to the sysadmin server role

ALTER SERVER ROLE [sysadmin] ADD MEMBER [domain\ntuser]

a) The rename should not break any logic in the package.

b) Yes, a new ispac will be required.