Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS variable display Expand / Collapse
Author
Message
Posted Friday, December 19, 2008 9:59 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, February 11, 2011 7:01 AM
Points: 91, Visits: 198
I have been trying to write a script to display the value of a variable
through a message box.

I have used this code:
MsgBox(Dts.Variables("StartDate").Value.ToString)

But i am getting some exception raised.



Post #623158
Posted Friday, December 19, 2008 11:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 3:18 PM
Points: 226, Visits: 720
Try

Dts.Variables.Item("StartDate").Value.ToString()

HTH
Post #623212
Posted Tuesday, November 8, 2011 2:49 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 9, 2012 3:55 PM
Points: 17, Visits: 102
Did you figure it out?
Post #1202498
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse