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 6 years, 3 months 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.

I'd suggest delving into the installation logs to look for a more detailed error message.