<div>
Use the DTS Package Properties dialog to create a global variable. This global variable can then be accessed in code.<br />
<br />
<br />
For example:<br />
<br />
<br />
Function Main()<br />
&nbsp; &nbsp;DTSDestination(&quot;FieldName&quot;<wbr />) = DTSGlobalVariables(&quot;NewID&quot;<wbr />).value<br />
&nbsp; &nbsp;DTSGlobalVariables(&quot;NewID&quot;<wbr />).value = DTSGlobalVariables(&quot;NewID&quot;<wbr />).value + 1<br />
&nbsp; &nbsp;Main = DTSTaskExecResult_Success<br />
End Function<br />
<br />
<br />
<br />

</div>


Use the DTS Package Properties dialog to create a global variable. This global variable can then be accessed in code.


For example:


Function Main()
   DTSDestination("FieldName") = DTSGlobalVariables("NewID").value
   DTSGlobalVariables("NewID").value = DTSGlobalVariables("NewID").value + 1
   Main = DTSTaskExecResult_Success
End Function





<div>
Thanks for help! I am obviously new to DTS but this was a very clear solution.
</div>


Thanks for help! I am obviously new to DTS but this was a very clear solution.

<div>
Don't get too familiar! It will probably change next version of SQL Server! than again that is a couple of years away.<br />
<br />
There are a lot of handy exmpaples here: SQLDTS.COM
</div>


Don't get too familiar! It will probably change next version of SQL Server! than again that is a couple of years away.

There are a lot of handy exmpaples here: SQLDTS.COM

<div>
<div class="content wysiwyg-content">
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:<br />
<br />
DTSDestination(&quot;id&quot;) = ?<br />
<br />
where ? is a command to autoincrement the id by 1. Hopefully this is just a syntax question. Thanks.
</div>
</div>


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.

Autofill an identitly field using an activex script in DTS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.