Thnks for the reply! However, I have decided to take a different route. I read somewhere on this site where somebody suggested making a enable bit in a table....

The number of records could probably reach the 10s of millions. I am going to try BCPing to a text file then Bulk Inserting to the table. I will let...

Try this link. It is from this site and works nicely: http://www.sqlservercentral.com/columnists/bszabo/dtsfilearrival.asp

Thanks,

I just got it working. Had to mess around with the field lengths. But, it works fine now

I tested it. Works perfectly. Thanks!

I forgot to mention that this file comes out without column headings. I had to use an insert statement to put them in with the data. Ugly. ...

I just got this to work on my server. I used the following code in an SP.

EXEC master..xp_cmdshell 'bcp "SELECT * FROM db.dbo.tablename" queryout C:\Directorypath\filename.csv -c -t , -U...

Yes, quite a help. Actually I figured it out yesterday. It is working nicely now. Do you have the company send you the DONE file only after the...

Ok, I am looking at the .DONE component and I think that I might see something wrong with it. Correct me if I am wrong:

In line 33 or so...

I am having problems with this procedure. I get an error on line 28 of the "Check for .DONE file" component. Where would I find this .DONE file? ...

I semi cheated. I have the SP insert the column names in the top of the table before it exports.

The issue is solved. I was using somebody else's code(ASP upload software) in the ASP page and I hadn't noticed that they did not include the adovbs.inc file. ...

Yes, through QA it works perfectly. It seems to have some sort of permissions issue. That is what error 208 denotes. I have all of the tables prefixed...

No, Same issue.

Here is the Stored Procedure which is nested:

CREATE PROCEDURE VO_Import @table varchar(50), @location varchar(100), @file varchar(50) AS

SET NOCOUNT ON

DECLARE @strSQL varchar(400)

SET @strSQL='BULK INSERT ' + ltrim(rtrim(@table)) + '...

Thanks, I think that you are correct.