32 bit ODBC Driver when running Task - VisualCron - Forum

Community forum

klewis10367
2011-12-09T21:02:12Z
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

Support
2011-12-09T23:38:56Z
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.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2011-12-12T13:07:18Z
Support
2011-12-12T13:12:59Z
Then you should have that feature. Have you checked this checkbox?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2011-12-12T13:32:41Z
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.

Support
2011-12-12T13:37:46Z
Hmm..right, not the Execute Task. But, isn't SSIS encryption only with password? What if you use a password?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2011-12-12T13:57:01Z
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.
Support
2011-12-12T13:59:55Z
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.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2011-12-12T14:27:45Z
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?
Support
2011-12-12T14:28:52Z
You could sent it to support@visualcron.com. Please keep it as simple as possible so we can reproduce the decrypt problem only.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2011-12-12T14:35:47Z
klewis10367
2011-12-12T15:23:02Z
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
klewis10367
2011-12-12T15:28:32Z
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?
klewis10367
2011-12-12T15:32:40Z
Never mind...Deleted and recreated job...all good.
Scroll to Top