asked on

SSIS-SCRIPT task

I enclosed the ssis package. In the packge the value in the script task needs to pass to package variable.
I need to pass Mid(FirstRow, i + 2, 8) value to labeler variable
user::labeler= Mid(FirstRow, i + 2, 8)
User::rate = Mid(FirstRow, j + 2, 8)

Thanks ,
coventri
Package-SSIS.txt

PedroCGD

whats the doubt?
You want to get first line and get a value and store it into a SSIS variable, correct?
Inside a script task you only need to do something like DTS.Variables("MyVariable").Value= newvalue

Give more details and I do a ssis package example for yoU!
Regards,
Pedro
www.pedrocgd.blogspot.com

coventri

ASKER

Hi pedro,

I need to pass the two count values in file into two different ssis variables,Instead of columns
sample data in file : 20084@RBT @RATE REC @00051187@LABELLER @00000442
I tried like DTS.Variables("MyVariable").Value= newvalue.But I got the error.

can you plz provide me example

thanks,
coventri

PedroCGD

ok... just a moment... I give you an example

ASKER CERTIFIED SOLUTION

PedroCGD

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

coventri

ASKER

Hi Pedro,

I need UVcount1 and UVcount2 must be integer instead of string.

Thanks ,
Coventri

PedroCGD