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, 9 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.

I'm sure that someone else will understand what is being requested here, but it's beyond me.

Can you please try explaining this again, because I don't understand what the problem is.

Note that @declare table is not valid T-SQL syntax – what do you really mean?

Can you...

While separating the transactions might help, it's not as good a solution as doing it in a single hit. I'll have a look, as, I'm sure, will others.

Something like this?

SELECT *
FROM dbo.Members m
WHERE m.memb_type IN ('Tier 2', 'Tier 3')
      AND NOT EXISTS
(
    SELECT 1
  ...