Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 633
  • Last Modified:

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
0
coventri
Asked:
coventri
  • 5
  • 4
1 Solution
 
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
 
PedroCGDCommented:
ok... just a moment... I give you an example
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
 
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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now