Hello! I have installed the 32 bit teradata driver on our SQL Server (Runs SQL Server 2005) and set up a 32bit ODBC using the odbcad32.exe found in SysWOW64. Now when I run BIDS on the server and run the package it completes successfully. The problem arises when I schedule the package to run and run it via the scheduler, I then get the error "Specified driver could not be loaded due to system error 126: The specified module could not be found <PATH TO tdata32.dll". I have checked the location and the dll is there and I have also re-installed everything as well as the ICU libraries. I have also check the PATH environmental variable and it seems to be correct so I have run out of ideas why it runs when I execute it via BIDS and not when the scheduler runs it :(

Can you run it in 32bit mode? http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html For 2008 it's this screen (not sure what it is for 2005) Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

when I schedule the package to run and run it via the scheduler More than likely the account that is used to run the schedule does not have file system permissions to access tdata32.dll BTW, when you say scheduler, do you mean as a SQL Server Job or a schedule in Windows Scheduler? If you mean SQL Server Job, you will need to create a proxy account and use it to execute the package. http://msdn.microsoft.com/en-us/library/ms190698(v=SQL.90).aspx http://msdn.microsoft.com/en-us/library/ms189064(v=SQL.90).aspxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Could you please check this Microsoft Support Article. This might help you. let us know your observation.. Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/

Hello, I have tried the above article but not sure what service I am meant to be looking for? I have tried looking for Teradata and ODBC but cant find anything like that in the list also the error is not happening on service start up its happening when I run a job from SQL management Studio.

Hello, I ave just tried re-installing the teradata drivers onto the share drive where we keep the package configuration files and so I am sure UKSQLSERVICE has access but I still get the same error except the path of the dll now points to the new install location.

Hello, Thanks for the suggetsion - unfortunately 2005 does not have this option and we need to run the job as a command line using the 32bit dtexec file which I am doing at the moment.

Hello, Yes sorry - it is scheduled to run from the SQL Server Studio under a different username - UKSQLSERVICE, whereas when I run it from bids I run it as the machine administrator (UKCRMADMIN) so that could be it. I have checked if UKSQLSERVICE has been set up as a proxy but there is nothing currently but we have other jobs running under that account so I am assuming the set up is ok except that normal ODBC drivers are in System32 but the teradata ones are in Program Files.... I'm by no means a DBA so a lot of this admin stuff goes over my head!

Hello, I have tried the above article but not sure what service I am meant to be looking for? I have tried looking for Teradata and ODBC but cant find anything like that in the list also the error is not happening on service start up its happening when I run a job from SQL management Studio. What's happen when you tried executing using the 32bit DTEXEC ?SSIS Tasks Components Scripts Services | http://www.cozyroc.com/