I have a post here already been waiting 4 hours for somehelp on this.
All I need to is call or Excute a update statement from a Script Task.
I have gotten few reply nothing is working?
Is it that hard?
From what I can see I need to dim a OleDbCommand
Set the connection
Set the connectionSting
Is there a way to call a connection already created in the package?
Yes CType(Dts.Connections(1).AcquireConnection(Nothing), Odbc.OdbcConnection)
But don't seam to come with the password?
http://qa.sqlservercentral.com/Forums/Topic602386-148-2.aspx#bm602802