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

Invalid column name 'data'

description

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 always this message : Unhandled exception has occured in your application.

Invalid column name 'data'

************** Exception Text **************
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'data'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
....

Do you have any idea to resolve this issue and get a Dependency between SSIS Packages and Tables ?

Thank you in advance

comments

kmartin wrote May 10, 2016 at 11:10 PM

  1. I haven't completed the ability to handle SSISDB, which is the SSIS Catalog. Microsoft didn't provided any native methods to access the packages within the SSISDB. I have a partially working version, but it's not released yet.
  2. I haven't seen this issue before. Is there any chance that you could send me a copy of the database that has your analysed packages in it? (Contact me directly, and I'll provide you with an email address to send the database backup to).

wrote May 11, 2016 at 12:00 AM