One additional step I tried:  

I'm trying to access an Excel 2010 file from network share using a UNC path.  This query actually works against the network share...

I realize this is an old thread, but I'm having the exact same problem sqldriver has described.   I've tried all the troubleshooting steps in this thread and got the...

I'm also having this problem on SQL 2008 R2. You could write an ugly parsing procedure to extract the schedule_id from the message field in the stepid=0 record of...

Well right after posting this question, I managed to figure it out.

I changed this:

Dim cmSource As ConnectionManager = package.Connections.Add("Odbc")

to this:

Dim cmSource As ConnectionManager = package.Connections.Add("ADO.NET:System.Data.Odbc.OdbcConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089")

And this

srcDesignTime.SetComponentProperty("AccessMode",...

I wasn't able to solve this problem, but I did find a way around it. I put myself through a crash course in XQuery and figured out how to...

Drive mapping was the issue. To fix it, we scheduled a job which runs the xp_cmdshell stored procedure to execute a bat file. The bat file has the...

I may have figured out what the problem is. I spoke with one of our network engineers and he mentioned that the DSN for the Pervasive database relies on...