search

keif888 / SQLServerMetadata

SQL Server Metadata Toolkit
Microsoft Public License
83 stars 32 forks source link

Invalid column name 'data' #6

Open keif888 opened 7 years ago

keif888 commented 7 years ago

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 ?

keif888 commented 7 years ago

kmartin wrote May 11, 2016 at 9:10 AM 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. 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).