I have a 2008 SSIS Package that uses a 32 Bit ODBC Driver to push data to a SQL server which is located in our DMZ...The SSIS package is encrypted with a password. For me to use this SSIS within Visual Cron i have to use the Execute task type because i have to encrypt the package password..when utilizing the SQL 2008 SSIS task Type it will not work...the problem i haver is that there seems to be know way to run the Execute task in 32 bit mode as there is for the SSIS Task..therefore my Job fails because our Servers are 64 bit and the task is trying to use the 64 bit odbc driver...this is the error in short:

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

I don't know which version you are running but in later versions you are able to select if you want to run it in 32 bit mode.

---

Version 5.7.5

Then you should have that feature. Have you checked this checkbox?

---

I have downloaded the newest version and i do not see an option for 32 bit mode for the Execute task...i understand there is one for the Execute SSIS Package...but since i have an encrypted password for my SSIS package...i have to use the Execute task instead of the Execute SSIS Package task.

Hmm..right, not the Execute Task. But, isn't SSIS encryption only with password? What if you use a password?

---

I does not work...the execute task was a solution that you guys suggested a while back...and it works great...but this is my first time with this scenario.

As we are no experts in creating a SSIS tasks, is it possible that you could create a small SSIS Task that really does not do anything and do not require a database - and encrypt it and we can test if decryption works.

If the the SSIS Package requires some output or other to verify that it works please add that so we can verify if decryption works.

---

Do you want me to send it to you...if so how...or do you just want the Error message that i get when i run the SSIS package and try to use the password option?

You could sent it to support@visualcron.com. Please keep it as simple as possible so we can reproduce the decrypt problem only.

---

Just sent.

I figured it out...need to put the location of the 32bit DTEXEC in the Command line..

C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTEXEC.EXE

instead of just DTEXEC.EXE

The funny thing now is that if i start the task at the Job Level it will not run..manualy or on a time trigger...but if i run by the task level it works fine?

Never mind...Deleted and recreated job...all good.