Dan,

You could import into a "staging" table with separate name columns, then concatenate as you move the data from there to your "real" table.

Greg

Francois,

Please post the error message you're getting and the format of your source file, and which DTS task you're using to import the data.

Thanks,

Greg

Rob,

Try this:

insert into new_table

select * from old_table

where not exists(select * from new_table

                       where new_table.clinickey = old_table.clinickey

                          and new_table.providerkey = old_table.providerkey

                          and new_table.phonecalltypekey =  

                                old_table.phonecalltypekey)

providing the 3 columns make up...

You probably have a corrupt index in the database.  Drop and recreate the indexes to fix.

Greg

Sorry, that's what I was trying to get at.  I don't work with Access databases a lot and I've never password protected one.  I'm glad you figured it out.

Greg

Sharon,

To prevent views from being imported as tables, you should use "copy objects and data between SQL servers" instead of the option "Copy table(s) and View(s) from source database" in...

In addition to creating a linked server connection, use OPENQUERY in your stored procedure to send a pass-thru query to the remote database.  See "Distributed Queries" in Books OnLine.

Greg

Sharon,

Remi's suggestion is good.  You could also use DTS to transfer objects between SQL Server databases and choose just the objects you want to put into your test database.

Greg

I don't think this forum software has that option.  You could post it in the suggestions forum.

Greg

What you do is run a script in Query Analyzer to generate ALTER TABLE DROP CONSTRAINT and ALTER TABLE ADD CONTRAINT statements for the foreign keys.  Copy the statements into Execute SQL...

Jacob,

I usually ignore the login and password for Access unless the Access database has had login enabled for a workgroup.

As for mapping differently named columns between an Access table and...

Are you certain that the developer is not a member of any other database role that may have DELETE permission?

Greg

How about SP_HELP_FULLTEXT_TABLES?

Greg

Our setup isn't anything like yours, so I don't know if you can glean anything useful from it. 

We do twice weekly full database backups, daily differential backups, and hourly...

IMHO, the easiest way to move packages is to open them in DTS Designer on the source server and "save as" to the destination server.

Greg