Hot answers tagged

4

Right click on the SSIS Catalogue, highlight Reports, and select All Executions. The Simple Talk article, SSIS 2012 Projects: Deployment Configurations and Monitoring by Feodor Georgiev, includes the following illustration: If you are not observing the Reports submenu, try running Setup again and choose Management Tools – Complete. Try executing SSMS ...


3

Left hand item is the "Available Input Columns". That's the data in your pipeline. The right hand item is the "Available Lookup Columns" - that's the reference data. When you click the check button, that adds the lookup entry into the pipeline. Thus, you are adding ContactTypeId as a new column and you are replacing ContactTypeDescription. That's likely ...


2

Check the blog post I wrote on SQLServer.science concerning how to identify this S-1-9 SID. From that post: This can happen as a result of using EXECUTE AS USER = 'SomeUser'; to switch context to another user that doesn’t have a server-level account. I imagine you'd see this exact scenario for contained users. There is also an MSDN post from 2006 ...


1

Sounds like you are interested in computed columns, https://msdn.microsoft.com/en-us/library/ms188300.aspx. The final column, InventoryValue is computed based on the QtyAvailable and UnitPrice columns. CREATE TABLE dbo.Products ( ProductID int IDENTITY (1,1) NOT NULL , QtyAvailable smallint , UnitPrice money , InventoryValue AS QtyAvailable * ...


1

Not sure if you ever got this solved, but I was able to find it in the GAC: C:\Windows\assembly\GAC_MSIL\Microsoft.DataTransformationServices.Controls\...\Microsoft.DataTransformationServices.Controls.DLL Let me know if that did the trick for you



Only top voted, non community-wiki answers of a minimum length are eligible