Yeah, only key and the only index

Well, thats my problem. I'm not sure how to create a format file from an SSIS Raw File. I was using the actual Raw file hoping that SSIS would generate...

Yeah, I already have the recovery mode set to "Simple" so there shouldn't be any logging. I'm thinking that it is probably the primary key index on the table. Would...

Its an OLEDB Destination and no there are no transformations between the raw file source and the OLEDB Destination

Sorry Vish for got to answer you. Yes there is a pk index on the table. This is all taking place on the same machine so I wouldn't think there...

Well, I was gonna to try a Bulk Insert but I couldn't find an answer to a problem I was having with the format file see the post at the...

Yeah, I have the "Table Lock", "Check Constraints", and "Keep identity" check boxes checked. Now that you pointed that out, I'm pretty sure that I should uncheck the check constraints...

I'm acyually using the Bulk Insert Task editor in SSIS 2008.

yeah, the raw file was created with the raw file destination task. How would I create a bulk insert to insert from the Raw file? I have to set the...

I've decided to use Bulk Inserts. How do I create the format file for the raw file? I tried setting it to select file then selected the raw file...

Thanks for the code but I'm curious as to how it works. Will it not just keep importing the top 100 everytime? I don't see how it will go past...

Well, the database file is sitting on a 1.5 terabyte drive all by itself and it hasn't taken up 10% of the space available.

Why do you need to insert 13...

I found the problem. The firewall was blocking me.

Yeah, TCP/IP was already enabled. Forgot to mentionthat before I guess.

I appreciate your help but the problem I have is that I won't have an existing key value that I can match them on. I do but that value is...