This project has moved. For the latest updates, please go here.

Reading package from SSISDB fails

Hi, I am trying to read packages from the SSISDB, as I am using project connection managers most packages fail. However the dependency analyzer does not even scan all packages. I have the followi...

Id #17692 | Release: None | Updated: Jan 10 at 2:16 PM by WillSampson | Created: Jul 28, 2016 at 8:41 PM by fmoeller

Order of execution of tasks within an SSIS dtsx file

Hi, I need to analyze the order of excecution of tasks within an SSIS dtsx files, and their dependency with different files dtsx in a SSIS project. Best regards Federico

Id #17665 | Release: None | Updated: Jan 10 at 2:16 PM by WillSampson | Created: May 18, 2016 at 8:05 AM by fcarta

Invalid column name 'data'

Hello, I have two questions please : 1/ Is the DependencyAnalyzer able to find dependencies directly from the SSIS Catalog ? If so, how indicate that parameter? 2/ While showing results, i get a...

Id #17662 | Release: None | Updated: May 11, 2016 at 1:00 AM by kmartin | Created: May 10, 2016 at 10:31 AM by aymen2

Analysis doesn't support SSIS DB Catalog

This was added to a closed issue: I am using SQL 2012 and store my packages in the new SSISDB catalog. When I select the server name containing this new SSIS catalog, the dependency executor is st...

Id #17549 | Release: None | Updated: Jan 10 at 2:16 PM by WillSampson | Created: Sep 30, 2015 at 12:12 AM by kmartin

On SQL Server 2008, enumeration fails on reportserver

During the running of the extractor in a SQL Server 2008, enumeration fails on the third report on the server. I opened this report, ran the report, and looked for anything unusual. The report se...

Id #17488 | Release: None | Updated: Sep 30, 2015 at 12:08 PM by kmartin | Created: Jul 31, 2015 at 6:18 PM by rav4john

Error analyzing SSIS 2012 packages with project connection managers

Hi there. I tried out analyzing some SSIS packages and tables in my SQL Server 2012 test environment and ended up with the following error: Error occurred: 'The connection "{B1505881-47D0-4DE3-9B...

Id #16010 | Release: None | Updated: Jan 20 at 10:22 PM by WillSampson | Created: Jan 29, 2013 at 10:27 AM by boriswerner

Dependency Executor Failing on Kimball Data Profiler SSRS Report

Part of our BI system includes The Kimball Group's Column Profiler report. When analyzing the data source of this report, which executes lots of DML using temp tables--as opposed to using a simple...

Id #15648 | Release: Alpha 13 SQL Server Metadata Toolkit | Updated: Jun 14, 2013 at 8:04 AM by kmartin | Created: Sep 25, 2012 at 9:30 PM by Mirsky72

SSASEnumerator doesn't find DSV-Tables, that are SQL Server Views

SSASEnumerator assumes that DSV-Tables with TableType "View" are "Named Queries" and only reads their "QueryDefinition". But there are also DSV-Tables with TableType "View", that represent Views fr...

Id #14969 | Release: None | Updated: Feb 14, 2013 at 8:03 PM by kmartin | Created: Mar 28, 2012 at 2:47 PM by j_maurer

Execute SQL task - SQL command from variable built from expression

I've been trying the tool out and I'm quite impressed. I have noticed one thing that doesn't seem to work though - we have some instances where we have an Execute SQL Task which runs a SQL statemen...

Id #14376 | Release: None | Updated: Feb 14, 2013 at 8:03 PM by kmartin | Created: Oct 25, 2011 at 2:57 PM by kmartin

Add Column Level tracking

Capture details on each column that passes through an SSIS package, and not what transformations are applied to it.

Id #11683 | Release: None | Updated: Oct 30, 2014 at 11:38 AM by hubermike84 | Created: Jul 29, 2010 at 11:19 AM by kmartin

  • 1-10 of 10 Work Items
    • Previous
    • 1
    • Next
    • Showing
    • 10
    • Work Items