Hi, I am receiving the "SqlCeCommand.CommandTimeout does not support non-zero values" message by clicking the Pase Query button in the Execute SQL Task Editor. The timeout value has already been set as 0. We use the SQLMOBILE connection type to connect to a SQL CE 3.5 database file through the SQL Server Compack Connection Manager Edition. The SQL statement is simple "DECLARE @MaxID AS int". Is there anyother configuration I need to do? Thanks

I think you need to take a second look at the connection string generated. is there a typo?Arthur My Blog

Hi ArthurZ, Thanks for your reply. The connection string geneerated seems all right. Anything else coudl I check? Thanks

Can you try with another SQL CE edition?Arthur My Blog

why not try to manual set the CommandTimeout in your code? http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlcecommand.commandtimeout%28v=vs.90%29.aspx#Y90 can you see in the CE connection manager whether you have a option to choose timeout setting? seems there isn't.If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer. Sevengiants.com

This is the answer to the problem On a 64-bit computer, you must run packages that connect to SQL Server Compact data sources in 32-bit mode. The SQL Server Compact provider that Integration Services uses to connect to SQL Server Compact data sources is available only in a 32-bit version. Please, check this http://msdn.microsoft.com/en-us/library/ms141253.aspx Hope it'll help you