When you are designing such SSIS packages in Visual Studio and if you have reference to any 32-Bit driver/dll then make sure you change Project Property Run64BitRuntime to False before you Debug your package in BIDS otherwise your package will try to load 64-Bit dlls instead of 32-Bit. Excel or MS Access Database Connections) must be called using 32 bit DTExec. There is no 64-Bit version of Jet Driver so any packages using Jet driver (i.e. If your SSIS package is referencing any 32-Bit DLL or 32-Bit drivers from your package then you must use 32-Bit version of DTExec to execute SSIS package.Ĭommon example of 32-Bit driver is : Microsoft Jet Driver (MS Access or Excel). On 64 Operating System when you install Integration Services it will install 32-Bit and 64-Bit version of DTExec commandline tool which is used to execute SSIS packages.ĭTExec 32-Bit can be found under : C:\Program Files (x86)\Microsoft SQL Server\90\DTS\BinnĭTExec 64-Bit can be found under : C:\Program Files\Microsoft SQL Server\90\DTS\Binnįor more information click on the following URL
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |