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
LVL 1
coventriAsked:
Who is Participating?
 
PedroCGDCommented:
Ok... Check the attached packaged! (Add it to a existent or new SSIS Project)
Update Valriable OriginalFilename and execute!
Helped?
Regards,
Pedro
www.pedrocgd.blogspot.com
SSIS-Interface.JPG
SSIS-ScriptTask-Code.JPG
SSIS-VariablesValues.JPG
Package-EE107c-dtsx.txt
0
 
PedroCGDCommented:
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
0
 
coventriAuthor Commented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
PedroCGDCommented:
ok... just a moment... I give you an example
0
 
coventriAuthor Commented:
Hi Pedro,

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

Thanks ,
Coventri
0
 
PedroCGDCommented:
change it into variables interface...
0
 
coventriAuthor Commented:
I got it Thanks Pedro.
which book is best to learn VB.net

Thanks ,
Coventri
0
 
PedroCGDCommented:
I can send you one by email!
Send me an email and we talk about that!
Regards,
Pedro
0
 
coventriAuthor Commented:
Hi Pedro,

email_id: prudviarrobotha@gmail.com

Thanks,
Coventri
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.