I need a small help.
This is what i require. I need to generate a auto increment number using script component and assign it to target column.
create table src
insert into src
create table trg
while loading the trg table, i need to generate a auto increment number and then load it to target.
Finally, my trg table data should look as follows
This is what i have done inside the package.
step1 : declared a global variable "tmp" of int32
step2 : created a connection manager pointing to "db1" database
step3 : drag n drop data flow task
step : inside the data flow task , i have the following
OLEDB Source (select name from src)
Script Component (i have added a new Output column "v_id" of int datatype in INPUTS AND OUTPUTS page)
In the Script page in Script component ,
in ReadWriteVariables | User::tmp, I have chose Visual Basic 2008 and clicked the EDit script and inside the Editor this
and inisde the below routine i have added only two
View Complete Post