.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Set oConn

Posted By:      Posted Date: October 24, 2010    Points: 0   Category :Sql Server


I have a DTS 2000 package with following code:

I migrated the DTS 2000 package to SSIS 2008, but the ActiveX script fails saying, "Object doesn't support this property or method: 'DTSGlobalVariables.Parent'"

Could someone help me modifying it so that it works with SSIS 2008.

Function Main()
Dim CurrDate
CurrDate = (Year(now()) & Right( "00" & Month(now()) , 2 ) & Right( "00" & day(now()) , 2 ) )

Set oConn = DTSGlobalVariables.Parent.Connections("File1")
oConn.DataSource = DTSGlobalVariables("FilePath1").Value & "File1_"    & CurrDate & ".txt"

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend