??

Not sure what your question is then. If the column is not-null and not identity, then you have to insert something into it. What you insert into it depends on...

Important piece of info missing - is the column an Identity ?

If it helps any, it's on my Sql2K install CD, under \devtools\include.

Been a while since I ran that installer, but I expect you need to select "Custom .." when running...

Since the general approach here seems to be to use a sledgehammer to drive in a small screw, I'd suggest removing the sledgehammer (T-SQL) and using the appropriate screwdriver (VBScript).

If...

I think you'll need to get into parsing the output of the FTP DIR command, then issue subsequent GETs based on that parsing.

Also note, File.Copy() is a procedure.

That means you either use Call and parentheses, or you omit call and parentheses:

Call fil1.Copy("\\icmrecamo\Alertes\AlertesInvalides" & DateComplete & ".txt")

or

fil1.Copy...

Then you're going to have to make your code more robust & report errors:

Set fil1 = fso.GetFile("\\icmrecamo\Alertes\ExportAlertes\AlertesInvalides.txt")

fil1.Copy ("\\icmrecamo\Alertes\AlertesInvalides" & DateComplete &...

First off, you definitely need the SET.

Second, this does nothing but waste cycles:

Set oRS = CreateObject("Adodb.Recordset")

Set oRS= DTSGlobalVariables("RSTables").Value

oRS is a reference. When you set it to the results of CreateObject,...

>>Isn't the less than pointless?

Why would it be pointless ? It depends on the functionality required. What if table2 represents some point in time, and you're trying to return all...

Check the user credentials of the login that SQL Agent is started under. Chances are it doesn't have necessary access permissions to a UNC share.

You're executing the dynamic SQL like this:

EXEC('INSERT INTO Project01tmp (' + @strColNames + ')SELECT '

+ @strColNames + ' FROM Project01PreTemp')

Try adding a PRINT statement to debug the contents of what's...

To wildcard the filenames, you're going to have to use dynamic SQL to generate the appropriate OpenRowSet statement.

You can use DTS. Or you can use T-SQL.

Here's a T-SQL example:

-- A...

So really, you need the intersection of column names between the 2 tables, right ? Only include a column in the Insert/Select statements if the column is in *both* tables...

>>The IDENTITY values won't be in order of field2 and 4?

Yes, they will, as long as the table is pre-created and you use INSERT INTO ... SELECT FROM.

The problem occurs...

I would check for SELECT's that use the TOP operator without an ORDER BY, where it is assumed (incorrectly) that records always come back in a certain order.

I would also...