How would I determine if the table has a clustered index or not? Is there a procedure for determining this?

Thanks Govinn. I am doing the same thing on two other files and they seem to be retaining their order when BCP'ed to the tables. The 'tables' are staging tables...

The .bat file that initiates the Bulk Copy is executed from a Task Scheduling program and is set to run every minute.

Ooops! I forgot to mention in my last post that I am using three separate staging tables for each of the file types.

The data is moved from the staging tables using stored procedures such as:

CREATE procedure rt_edt_sp

as

SET ANSI_NULLS ON

SET NOCOUNT OFF

declare @trg_sub_code varchar(8)

declare @mid varchar(10)

declare @callsign varchar(6)

declare @src varchar(1)

declare @id varchar(4)

declare @cid...

Thanks govinn. I am using a staging table to store the data from the bulk copy, and then I use the following to insert the data into the production table:

CREATE...

Thanks David but that did not seem to work. The two tables that I am working with do not seem have the same identity values....I guess that was due to...

Farrell, I would like to return data that is in table B but not in table A. Is it possible to modify your query above to do this? If so,...

Got the following error:

Server: Msg 7202, Level 11, State 2, Line 2

Could not find server 'icedata' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

I also forgot to mention that the two databases are on separate database servers. Can this still be accomplished using the code above?

Thanks Steve and Farrell. Farrell, can I use the following to get the records in development that are not in production:

SELECT DEV.IdentityField AS 'Dev IdentityField',

             PROD.IdentityField AS 'Prod IdentityField',...

Would I have to connect to both databases in the script, say:

Use dbo.databaseA

insert into table A (column1, column2, ...)

Use DatabaseB

select from (column1, column2, ...) from table B where ....

Or how would...

Thanks again Remi!

Yes, I did try moving that code but I wasn't getting the desired results. I had to call another stored procedure before opening the cursor that would parse through the...

Thanks Chris and Site Owners. I will use the link provided to give suggestions and/or feedback. Once again, thanks for the help! I just want to help make the product...