Saturday, February 25, 2012

64-bit issue

I am running into a strange problem when trying to run my package against 64-bit version of SQL Server 2005.

The package was initially developed with a CTP 2 version of SSIS. It has been running fine against a 32-bit bersion of SQL Server 2000.

I created a new SSIS project, with the release version, and added the package mentioned above. Things still work fine against a 32-bit version of SQL Server 2000. However when I run the same exact package against a 64-bit version it doesn't work correctly.

I am using a flat file connector - to pull data from a text file - and loading the data into a database table. Each time I run against the 64-bit version of SQL Server 2005 the number of nulls - for a particular colum - changes.

In other words, the following query returns different counts each time the package is run - even when the underlying flat file data hasn't changed:

select count(*) from some_table where email_address is null

Any help would be much appreciated!

Scott

I now have more information about the above problem. It appears that this is *not* a 64-bit issue. If I run the package using the CTP 2 version of SSIS, everything is correct on 32 or 64 bit versions of SQL Server.

However, if I take the same package and run it within the RTM version of SSIS, the numbers are not only incorrect...the numbers change with each run of the package!

Note that the flat file data source remains the same.

Is there some issue with taking a package built with CTP 2 and runnig it directly with the RTM version of SSIS?

Thanks,

Scott

|||

Wouldn't do it. I would create the package from scratch. There was no supported upgrade from CTP to Beta (that I am aware of) and that includes the packages.

Based on experience, not only remove any signs of the CTPs, but rebuild any machine that any component of a non RTM version on it. It just removes the possibility of error, and I would suspect if not done invalidate any support.

No comments:

Post a Comment