SQL Server Business Intelligence

SQL SERVER 2005 & 2008 IS THE MAIN THEME OF THIS BLOG

Friday, July 07, 2006

Sample Project / Package to Re-Pro 64 Bit Issue

Microsoft said, they couldn't reproduce the problem from Scratch, but I have. I have sent it to MS as well. I have attached the whole project (with all the packages) and configuration files.

Master Package
[1] Creates a simple table in tempdb database if it doesn't exist else it will truncate the table.
[2] It will populate 25 records into that table.
[3] SQL will get those 25 records and assign them to a Object variable.
[4] Foreach Loop (ADO) and set the values of each row to couple of variables. Inside that foreach I have an execute package task, which will call another package (in this case Pkg_Sample25.dtsx)

I have got 52 packages in this project. All the packages except Pkg_Master is exactly same. They all have one single Execute SQL Task, which has a SQL statement as "SELECT 1".

Every package has connections for all 51 packages and 55 flat files. All these are configured in the configuration file (64BitConfig.dtsConfig) which is located in a directory called "C:\RePro\Config". Please note you would need to change servername in the configuration file before you execute the package. You will need to change flat file directory and packages directory if you put them anywhere other than "C:\RePro".

If I run a package called "Pkg_Master" on my laptop (32 bit), it executes under 50 seconds. If I execute same package on a 64bit machine it executes just under 7 minutes (6min 42 Secs).

If anyone wish to download the sample project and try it on there 64 bit box, you can do it from here.

Thanks
Sutha

0 Comments:

Post a Comment

<< Home