Import Some Data From Access To SQL Server

I have created some DB tables on SQL Server. Now I want to import some data from Access using Data Transformation Services.

The APPLICATION table I have created has the following columns:

AppID, AppName, AppMnem, GripsID, Decommissioned, Last Modified, Modified By

AppID is the primary key and is an identity column with an autoincrement on insert.

The query I used to import the data from Access is:


select `T>Application>General`.`Application Name`, `T>Application>General`.`Application Mnem`, `T>Application>General`.`GripsID`, `T>Application>General`.`Decommissioned`, `T>Application>General`.`Last Modified`, `T>Application>General`.`Modified By`
from `T>Application>General`
where `T>Application>General`.`Application Mnem`='TMS'
order by `T>Application>General`.`Application Mnem`


The transformation I used is:


'************************************************* *********************
' Visual Basic Transformation Script
' Copy each source column to the
' destination column
'************************************************* ***********************

Function Main()
DTSDestination("AppName") = DTSSource("Application Name")
DTSDestination("AppMnem") = DTSSource("Application Mnem")
DTSDestination("GripsID") = DTSSource("GripsID")
DTSDestination("Decommissioned") = DTSSource("Decommissioned")
DTSDestination("Last Modified") = DTSSource("Last Modified")
DTSDestination("Modified By") = DTSSource("Modified By")
Main = DTSTransformStat_OK
End Function


However, I keep gettting the following error:


Error at destination for row number 1. Errors encountered so far in this task: 1.
Instert error, column 1 ('AppID', DBTYPE_I4), status 10: Integrity violation; attempt to insert null data or data which violates constraints.
Unspecified Error


Any ideas as to what the problem is?

Thank in advance