Thank you!

Thank you. Yes, I'm aware of that, Microsoft says the SPLIT can be resource intensive, but it doesn't say it moves the data, hence my confusion.
I am having...

I've been trying to find what I read, now I think I must have misinterpreted the fact that you can/ have to rebuild a table on the newly created partition...

From what I'm reading, this setting is only a hint used by the Optimizer:
ROWS_PER_BATCH =rows_per_batch
Indicates the approximate number of rows of data in the data file. ...

thank you, that works, too!

a friend figured it out.. here is is:

select * from test

where id = 3

union all

select * from test

where c2 =

(select c1 from test where id = 3)

As an example:

CREATE TABLE [dbo].[Test](

[id] [int] NULL,

[c1] [varchar](50) NULL,

[c2] [varchar](50) NULL

) ON [PRIMARY]

INSERT INTO Test

([id]

...

I've tried that, too - only 'where c1=c2' doesn't work, either.

That does not work, I've tried it.

Update: now the package runs and appends records when the email task is present. The next surprise came when I ran it as a job: it appended records, but less...

I reversed the last 2 tasks, the one that wasn't working and the one that was newly added, and it started working again. I guess there must be some corruption,...

Jeff Moden (12/11/2013)

---

Marius.D (12/11/2013)

---

Someone said something like "Always do what makes sense". I vote for that!

It never stops amazing me how "solutions" are discussed as if they would work universally....

Someone said something like "Always do what makes sense". I vote for that!

It never stops amazing me how "solutions" are discussed as if they would work universally. Most of them,...

ScottPletcher (2/11/2013)

---

Marius.D (2/11/2013)

---

Scott:

I did not, but would that make a difference? I didn't think the missing...