Thanks for the detailed answer.

Thank you very much for quick response.

bump!

Nope, You can't just use UNC and copy the file, I believe everything is stored on SQL server not on file server.

Yes I can drop and recreate, but I have to create indexes too... and I am curious why its not doing what it ssuppose to do?

I am in same situation but little bit different. My destination servers are sql server 2000, is there any command to disable indexes while inserting into tables?

I used import wizard in SSMS to import data and stored as package. Can I open the package in SSMS?

mak101 (9/6/2010)

Jeffrey Williams-493691 (9/6/2010)

mak101 (9/6/2010)

WayneS (9/6/2010)

On that same screen (Column Mappings) is a check...

Jeffrey Williams-493691 (9/6/2010)

mak101 (9/6/2010)

WayneS (9/6/2010)

On that same screen (Column Mappings) is a check box...

Jeffrey Williams-493691 (9/6/2010)

mak101 (9/6/2010)

WayneS (9/6/2010)

On that same screen (Column Mappings) is a check box...

WayneS (9/6/2010)

On that same screen (Column Mappings) is a check box for "Enable Identity...

And I saved it as SSIS package on the server. But I don't find the way to open it. Can you please help?

Thanks.

Thank you found it.

Another question- How do I keep same identity value from original table?

Thanks all of you working on it.

I was working hard on it and I finished it but not in one query, I dumped all data into #temp table and loop...

What I need is, on a given date which employees were on tour and which region? Along with it, I need their tour start date, tour end date, first order...