SQL SERVER 2012 SSIS SSIS 2012 - Package Configurations Menu Option Missing

Recently, I have come across the issue that the package configuration option menu was missing when I right click the control flow. The reason is that there is a change in the SQL Server 2012 environment, when you want use the Package Configuration Menu first time by clicking the ellipsis button next to the Configuration property. The Configuration property appears in the properties window for the package. After you configured the first variable that it will be appearing for right click.

The following image shows while right click before configuring any variable.

The following image show ellipsis button next to the Configuration property.

The following image shows that after configuring the first variable

Refrence: http://technet.microsoft.com/en-us/library/ms141132.aspx

Publishing data only using SSMS

You might come across the problem while generate the script using Data only option in SQL Server 2008 R2 – SSMS.

The Error message appears normally as follow:

Microsoft.SqlServer.Management.SqlScriptingEngine.CyclicalForeignKeyException: The selected database contains foreign keys that create a cycle. Publishing data only is not supported for databases with cyclical foreign key relationships. at Microsoft.SqlServer.Management.SqlScriptPublish.GeneratePublishPage.worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

Solution: Use the SQL SERVER 2012 –SSMS.

Cheers!