Script odbc connection windows 7

Open the Script Transformation Editor. On the Inputs and Outputs page, rename the input with a more descriptive name such as MyAddressInput.

On the Script page, click Edit Script , and then enter the script shown below in the ScriptMain class. Close the script development environment, close the Script Transformation Editor , and then run the sample. Creating a Destination with the Script Component. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback?

Reply 5. Facebook Twitter Reddit LinkedIn. Josh Rogalski. Main Areas of Contribution:. Track Progress. Earn Credits. Step 3: Run application again. DavidHeath Oct 2, at pm. KeithFS Nov 7, at pm. Jordan Sanders Sep 2, at pm. Archived Forums. The Official Scripting Guys Forum! If your answer is "yes," you know what to do.

Dive in and help somebody! If your answer is "no," welcome to our fun little world! We'd recommend that you first head over to the Script Center, get your feet wet, and then come back to either ask or answer questions.

We can't be everywhere at once we know—shocking! The Microsoft Scripting Guys 2 3. Sign in to vote. It seemed to me that wscript. With that in mind, I found a way around the error by running my script via the 32bit version of Windows Script Host. What I really want to know is if there is a way to run my script via the 64bit version of wscript. Is there a specific connection string I can use or am I just out of luck until Microsoft puts out 64bit Excel drivers?