Project Connection Manager in 2014

Hi guys it seems that using a Project Connection manager (CreateInProject="true") does not produce any effect in Visual Studio 2013. Can anyone confirm this, or I'm the only one have this problem...

Id #35400 | Release: None | Updated: Mon at 1:37 PM by manowar | Created: Mon at 1:37 PM by manowar

Use MeasureGroupMeasures for tabular actions other than drillthrough

Actually, I spoke too soon. I still can't limit the action to a specific measure group. Here's what I'm seeing on the BIDS Helper Tabular Actions Editor: select Action Type = Drilldown select Ta...

Id #35292 | Release: None | Updated: Jun 13 at 5:00 PM by furmangg | Created: Jun 13 at 4:58 PM by furmangg

SSIS project properties doesn’t show Deploy (BIDS Helper) option when it’s under a folder

I can see the Deploy (BIDS Helper) option on properties of a SSIS project when it’s under a Solution, but this option is not shown when it is under a folder (see attached). I’m using SQL Server 200...

Id #35218 | Release: None | Updated: Jul 12 at 1:03 PM by SweetSirena | Created: May 14 at 4:52 PM by MonicaMolina

SSIS: Unused Connections in Connection Manager

As an enhancement, I would really like a way to find out which connections in the connection manager are not being used by any project component. This could either be a list, or maybe an icon updat...

Id #35175 | Release: None | Updated: Apr 30 at 9:29 AM by icowden | Created: Apr 30 at 9:26 AM by icowden

SSIS:Performance test fail when having Project parameters

When trying to run the Performance test (VS2012) it fails during validating the package. In the output window I read "Failed to lock variable "$Project::SomeVariable" for read access with error 0xC...

Id #34974 | Release: None | Updated: Feb 12 at 3:21 PM by PelleSunkan | Created: Feb 12 at 3:20 PM by PelleSunkan

BIML: Execute SQL Parameter DataType Mismatch

Given the following BIML: <ExecuteSQL Name="SQL Log Row Count" ConnectionName="MyDb"> <PrecedenceConstraints> <Inputs> <Input OutputPathName="DFT Stage Incoming File.Output"...

Id #34962 | Release: None | Updated: Feb 6 at 7:29 PM by lotsahelp | Created: Feb 6 at 2:38 PM by lotsahelp

SSRS: Copy and Paste a Parameter (new feature idea)

I have an idea for a new BIDS Helper feature. Using the SSRS Report Designer, I wish I had $1 for every time I have had to "copy and paste" a parameter definition - typically from one report to an...

Id #34896 | Release: None | Updated: Jan 16 at 2:57 AM by MikeHoney | Created: Jan 16 at 2:57 AM by MikeHoney

SSAS: detect mismatch in other datatype bindings besides dimension

There are a few scenarios BIDS Helper can't detect: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1e432b5d-aea5-4840-a4a4-ef863f9c213b/errors-in-the-backend-database-access-module-the-siz...

Id #34765 | Release: None | Updated: Jan 16 at 2:48 AM by MikeHoney | Created: Dec 22, 2013 at 1:56 AM by furmangg

SSIS: Batch Property Update and Source Control Encoding

Hi all, after I update a property value using the Batch Property Update, if my project is under TFS and I do a Check In, I get the warning you can see as attachment: "The character encoding for th...

Id #34661 | Release: None | Updated: Feb 12 at 3:00 PM by PelleSunkan | Created: Nov 19, 2013 at 2:08 PM by lucazav

SSIS/BIML System variable not recognized

This line of BIML code results in an error: <Variable Name="ExecutionID" DataType="Int64" EvaluateAsExpression="true" IncludeInDebugDump="Include">@[System::ServerExecutionID]</Variable> When re...

Id #34582 | Release: None | Updated: May 2 at 6:44 PM by ssisjoost | Created: Oct 21, 2013 at 7:49 AM by shoeff