Friday, May 29, 2009

SQL Server 2008-32 Bit Runtime...

We have a decent size of SSIS packages in Sql Server 2008 where in i import data from Excel Data sources. These SSIS packages run on a SQL Server 2008 box which has a 64 Bit installation of SQL Server. Since Excel is a 32 bit application, in order for the SSIS packages to work I had to use the command line option to run the SSIS packages where in i can invoke the 32 bit SSIS runtime so that it would work with the Excel Data sources. In Sql server 2008 one can use the SQL Server Integration Services option and set the 32 bit runtime check box. This option is available in the Execution Options tab. This way one can move away from the command line option. Here is a snapshot of setting:

No comments:

Post a Comment