You can make it a two step process:

1st sql task: do the insert

2nd sql task: pull identity into global var

link 1st and 2nd task with a "on success" workflow

/Kaare