April 2009 - Posts

• SSIS package fails when Package Configuration is enabled using XML

  I thought I share this with you, before you waste time like I did. If you are planning to deploy an SSIS with "Package Configurations" enabled using XML file, and if one of the dynamic properties is the "ConnectionString", you MUST add the "Password=xxx" yourself into the string. The Wizard won't store it. Good luck   --tolga Posted Apr 29 2009, 05:18 PM by kemaltolga with no comments Filed under: SSIS, Package Configuration

• "Full text index" optioni is grayed on database table

  Here are the steps to enable this Make sure the SQL Server FTS is running Click Start, Programs, Microsfot SQL Server 2005, Configuration Tools, SQL Server Configuration Manager Select SQL Server 2005 Services Find "SQL Server FulltextSearch" Enable/Start the service Go back to SSMS (Management Studio) and open a query window. Execute the following query...                                use [database name] exec sp_fulltext_database 'enable'   Good luck... Posted Apr 16 2009, 10:44 AM by kemaltolga with no comments Filed under: SQL Server 2005 Full text search