Solved

How do I read a user defined variable into a ssis script task and then output a value?

Posted on 2010-09-01
8
380 Views
Last Modified: 2013-11-10
How do I read a user defined variable into a ssis script task and then output a value?
0
Comment
Question by:Mr_Shaw
  • 4
  • 3
8 Comments
 
LVL 14

Expert Comment

by:Emes
ID: 33578940
0
 

Author Comment

by:Mr_Shaw
ID: 33579011
I read it am it went over my head.

Any easier examples.
0
 
LVL 16

Accepted Solution

by:
vdr1620 earned 500 total points
ID: 33579270
If you just want to read from variable ..you can use below script
Public Sub Main()
    Dim Column_Name As String
    Column_Name = ReadVariable("VariableName")
End Sub

Open in new window

0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:Mr_Shaw
ID: 33579396
How do I read one variable and then write to another user defined variable
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33579418
are you trying to convert an Object Variable to User Variable and load data into user variable..Is that the case?
0
 

Author Comment

by:Mr_Shaw
ID: 33579433
No I have a Access FIle Name I need to change to update a connection.
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33579590
can you explain what you are trying to do?
0
 

Author Closing Comment

by:Mr_Shaw
ID: 33588652
thanks
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question