I have a vbscript that copies and transforms data from an access table to and existing MSSQL table. The destination table has an identity column, and I need to autopopulate it as the data is loaded. I'm thinking the line of code would look something like:
DTSDestination("id") = ?
where ? is a command to autoincrement the id by 1. Hopefully this is just a syntax question. Thanks.