Is this the case also on your copy of the environment?

declare sorder cursor for

select SRREFERENCE

--,@updateflag = SlaUpdate

from inserted

open sla

FETCH NEXT FROM sla INTO @salesorder

WHILE @@FETCH_STATUS = 0

BEGIN

Would this cursor not only gather one row? (I assume you meant that...

Good point on the results to text. I have the habit of throwing the results to grid, doing a click on the select all corner of the results tab, copying...

EXEC SP_HELPTEXT 'schema.viewName';

This formats the output across multiple lines rather than just one. I find it way handier when copying long definitions to the SSMS window.

phil.doensen (1/15/2015)

---

You should also do explicit database log backups (as well as normal backups) or make sure your recovery model is set to "simple" or your log file will grow...

I have not seen a mention of the Data Flow task. That is SSIS's bread and butter item for moving data around. Since you mention about 4000 rows per batch...

I think the business intelligence products (SSIS , SSAS , SSRS ) are a huge plus if you are looking at the warehousing side of things and not...

I think the OP may just want a general illustration , may not be solving anything in particular. Here is another method :

declare @t table

(

ID int

...

The screen shot shows your initial size for the first file at 155GB, not 100GB.

If this picture is incorrect I can suggest tinkering with the data management views to detect...

You could go the way of variable expressions here with a data flow within the for loop container. Unless I am missing something you could:

variable,

type,

expression

-----------------------------------

StaticFolderNum,

int32,

no expression...

For the plan that still does not work, did you try changing the "Local Server Connection" in the maintenance plan to a custom one with the account used being Windows...

Glad you worked this out, as I suspected from reading the thread that it was some strange conversion taking place. I have found that converting to string in these situations...

You could include both of the timestamp datetime fields in your table design. Call one like DateTimeModified, the other like DateTimeLoaded. In your (I assume) daily ETL you could select...

Is this a one time event? If so I can offer a quick and dirty method :

1. In SSMS go to Tools > Options > Query Results>SQL Server> Results to...

bantrim (12/31/2014)

---

MMartin1 (12/31/2014)

---

One of the tweaks I do is alter the max rows per batch and or commit size when transferring millions or rows with SSIS's, dataflow's ole db destination....