lol...thanks aljtdj

aljtdj, if its easy to do what you suggest, maybe Newton should go with that. 

However, Newton, if you want to do it the right way

I would avoid Access at all costs....especially if you have SQL at your disposal.

Newton, if you still want to go the SSIS route, you will have to build a package...

When you import all of these tables, are each of the tables going into their own tables or do they all go into one common table?  Or if you import...

Hey Newton,

Sorry for the delay here.

Just as I thought yesterday, there is no way that SQL Server can automatically detect changes in an Access DB.

But, as I said, you can...

Hey Newton,

I'm at home right now, but I'll look in the morning to see if I have anything that might do that. Unfortunately i dont think there is a...

Hey,

What do you mean by constantly?  I do this kind of import and update of SQL tables.  Give me a littel more information and I'm sure I can help you...

Thanks Robert!

Thanks what thought as well.  I am pretty sure the only way to get around Access locks is to phase out Access.

Thanks for the tip about changing the copy...

That was attempt number one actually, util I was told that each "Teams" data may be different.  Once I tried a different team, no dice.

The dynamic sql and cursor did...

Thanks Andrew for the link, however, after a few coffees, and some quiet, I was able to do it with a nested cursor.  I know, avoid at all costs, but...

Hey Gary,

Here is what I was able to do.  It uses dynamic SQL, so the @xOrderByColumn is a parameter

ORDER BY

-- We need a case option for all existing...

Hey guys,

After a couple of head pounding hours I got it to work. I need the dynamics of it as this will be used in an application that will...

I agree. The metrics and distribution were tested on the smaller table to ensure that when we exploded it 10 fold, which is now 100 after last night, would...

This purpose was not a result set test as it was a resource and system time test. The end result metrics will have to be QA'd, and that table...

I need to test a process which involves run time. Once the actual "real" table is produced, we will be running reports based on certain metrics. The long...

Here is the code. It works fast....50mil start, 500mil final.

Declare@StartPointint,

@minstoreint,

@MaxStoreint,

@IncrimentSeedint,

@Countint

SET@StartPoint=0

SET@minstore=1

SET@MaxStore=500

SET@Count=(Select Max(PlaceID)

From Schema.SchemaTestStage)

WHILE@minstore <= @Count

BEGIN

SET@IncrimentSeed=0

WHILE@IncrimentSeed<10

BEGIN

BEGIN TRANSACTION

...