yeah..

its doing more than that - it just happens that today (Sunday) happens to be a week boundary.

try it with multiple dates (consecutives, spawning 2 -3 weeks) instead of getdate...

"0" (zero) on these cases means the default value for datetime - which you can determine by a simple change to that code (or by reading the manuals)

are you sure? did you run it? and does it really look like the number of weeks that 20 years would have?

looks clear enough for some one with your level of experience.

so what seems to be your question after you have run "select DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0)" to see its result?

there is a way - I'll need to dig trough my c# code to find it.

basically a c# that loads the package, loops through the scripts and recreates them using...

I've used  Sparxs EA Both as individual and within the corporation . Price isn't that bad

rather surprised that table variable are faster.

normally if the necessary indexes are added to the temp tables performance is similar if the table variable also has the same...

rather surprised that table variable are faster.

normally if the necessary indexes are added to the temp tables performance is similar if the table variable also has the same indexes.

As for...

note that as long as you have Enterprise version you can use the Attunity driver - does not need to be the 2019 version, and as they say on the...

DefaultBufferMaxRows = 2000 -- change to 50000

DefaultBufferSize = 1048576 -- change to 10485760 ( x 10 basically)

tablock = set to true so it can use minimal logging

connection string - set...

are you sure that tbl_name  is really a table and not a view?

that SQL so simple would give that error if it was from a view with invalid data on...

well.. it depends..

Today I've loaded 16 Million records in 34 mins - 650 bytes per row - table already had 50 Million rows

and this is loading onto a staging table...

Others will comment - most likely with better answers than mine.

regarding the 1 min interval - that is the default on 2016+ but it can be set in seconds so...

to "develop" the SSIS package you need 32bit versions of the clients as Visual Studio is a 32 bit application.

you can have both 32 and 64 bit versions of the...