title: Early bind microsoft activex data objects 6.1 library in SSIS VB script
body: <p>I am trying to convert several of my ms access VBA scheduled tasks over to SSIS. 
  In VBA I use the  <code>microsoft activex data objects 6.1</code> library. To my surprise,  much of my code compiled fine. When I try to execute the task however, I am presented with a non-sense runtime error. I was also getting warnings about late binding. My thought is that perhaps if I can remove the late binding and early bind, the error might go away</p>
  
  <pre><code>Public Sub open_ADOConn(Optional connection_String As String = postgresConnString)
      ADOConn = CreateObject("ADODB.Connection") 'late binding
      ADOConn.ConnectionString = connection_String
      ADOConn.Open
  End Sub
  
  Public Sub Main()
      ' Add your code here
      Call open_ADOConn()    'call 
      Call MsgBox("hello")
      Dts.TaskResult = ScriptResults.Success
  End Sub
  </code></pre>