Thanks much.  Basically what I'm doing is DTSing 33 rows from a .csv file to my table - so it doesn't look like I need to set identity insert on..  ...

I really can't just delete the original table..   I need to be able to roll back if the rows being inserted in the original table have any adverse effects..    Plus,...

When I do this.. I'm still getting the below error....

truncate table mytable

go

set identity_insert mytable on

go

insert into mytable

select * from mytable_temp

go

set identity_insert mytable off

go

Server: Msg 8101, Level 16, State 1,...

was able to figure this much out with a little help....

TO ROLL BACK

truncate table mytable 

insert into mytable

select * from mytable_temp

Now I'm getting this error:

Server: Msg 8101, Level 16, State...

OK.   I have to truncate the original table before moving data back into it..  but what is the syntax to copy the data back to the original table?? 

WOW!  a reply to an almost 2 year old post ...  must be a record!!!! 

Since I cannot connect to the Destination Server (it is on an entirely different Network at a 'sister company') I'll try  saving  the DTS package as a Structured Storage File...

Awesome.  Thank you!

Thanks much!!!!!!!!!!!!!

yes.  Column.

Thank you MUCH!

I don't know if I can help with your particular problem ...   but I do know that I've gotten GP help (both GP Application and Backend DB help) on this...

I Backup ALL my databases locally and to a Network SHARE.

I use \\Servername\sharename\foldername   for the Backup Destination

Make sure that whatever Domain Account you are using to Start SQL Server...

If you are using one maintenance plan for both Full and xaction log backups, did you choose User Databases only or are you trying to backup ALL databases including the...

That was my feeling too.. 1 CAL for each Citrix Client - regardless of how many Citrix Based APPS they use - they all hit the same SQL Server.. 

My...

yes. that would be 50 MSSQL User CALS and not processor licenses that we have..

I don't reall make the decisions.. I was just asked to find out how the...