Yes, I created a variable called connString, and it contains the connection string. Be sure the connection string doesn't contain the "Provider" keyword, as the OLE DB connection will not take that. Take a look at http://www.connectionstrings.com for help with the connection strings.

Also, be sure that you expose the variable to the script task by adding "connString" to the ReadOnlyVariables section of the script editor. Here's how:

- Double click the script task

- Click "Script" from the menu on the left

- Find the property "ReadOnlyVariables" and type in "connString"

There are other ways to get that connection string, including hardcoding it in the script. I'm more of a .NET developer than an SSIS guy, so this way made the most sense to me, and was honestly the only way I could get it to work myself.

Hope that helps, but if it doesn't, what error message(s) are you getting?