Relative paths in SSIS project

In a dtproj file, the project item full path can be relative (i.e. ..\BimlScript.biml) and unfortunately these are ignored when "Generate SSIS Packages" or "Check Biml for Errors" are used. Lookin...

Id #35539 | Release: None | Updated: Sep 11 at 10:58 PM by guinness | Created: Sep 11 at 10:58 PM by guinness

Flat File Format row delimiters

SSIS interprets the last column's delimiter as the actual row delimiter. This requires the developer to hard code the last column to the row delimiter. When Generating SSIS packages from BIML, BI...

Id #35534 | Release: None | Updated: Sep 9 at 10:51 PM by peacewon | Created: Sep 9 at 10:51 PM by peacewon

SSAS and SSIS projects Unsupported after install

I was not clear what version I needed for vs 2012 + SQL 2014 so I first installed 2014 version of bids helper. This gave me no BIDS Helper short cuts in my solution. So I installed 2012 version nex...

Id #35533 | Release: None | Updated: Sep 9 at 10:46 AM by furmangg | Created: Sep 8 at 11:19 AM by Zak22

<Annotation> section -- still pesky after SP2 installed

Pls note that we are getting the "readElementContent() methods cannot be called on an element that has child elements" when sourcing a SSAS (Tabular) project created with SP2 (no CU applied after ...

Id #35518 | Release: None | Updated: Sep 4 at 3:48 AM by dgosbell | Created: Sep 2 at 11:31 PM by cosmini

Lookup NoMatch output not recognised

Hi, I'm using VS2013 and SQL2014 and seem to be having an issue with the lookup. My pattern is for a fact lookup to dimension. When there is no match I pass this to a derived to update the key to...

Id #35489 | Release: None | Updated: Aug 22 at 10:30 PM by jbb352 | Created: Aug 22 at 10:30 PM by jbb352

Different suffix for drillthrough action name

I have created drillthrough actions in a cube for measures in a measure group. When I right click on the different measures > Additional actions - a different number gets suffixed to the action nam...

Id #35434 | Release: None | Updated: Aug 3 at 1:33 PM by gssahasr | Created: Jul 31 at 9:31 AM by gssahasr

BIDS 'hidememberif' 'NoName' causing SSAS to hang

I have used BIDS many times to create hierarchies and set the 'hidememberif' value to 'NoName' in more than one SSAS model. However, I have an issue with one SSAS model and one dimension in which ...

Id #35428 | Release: None | Updated: Jul 29 at 3:38 PM by mkirby | Created: Jul 29 at 11:34 AM by mkirby

Sort aggregations based upon size

http://blog.oraylis.de/2014/07/ssas-optimization-the-order-of-aggregations/

Id #35423 | Release: None | Updated: Jul 30 at 8:13 AM by muk242 | Created: Jul 28 at 11:39 AM by furmangg

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: Aug 11 at 5:08 PM by manowar | Created: Jul 21 at 1:37 PM by manowar

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