November 14, 2008 at 12:15 pm
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://www.sqlservercentral.com/Forums/Topic602386-148-2.aspx#bm602802
November 17, 2008 at 1:42 pm
You really don't need to cross post as either someone will know the answer or not. As noted answers should be made to the other thread found here
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply