December 14, 2015 at 8:46 pm
Divya,
Hi I wanted to thank you. Your script and the time you took to answer questions related to problems that I was having were a life saver.
It is good to know that there are folks like you willing to take time and extent a hand to a complete stranger.
Brilliant piece of code.
Thank you again for all your help.
November 4, 2016 at 9:27 am
I missed the article the first time around but just read it.
The fact that SSIS packages are XML files makes documenting SSIS so much easier provided you have a basic understanding of XML (ditto SSRS and many other MS products). Great work - it's great to see someone demonstrate how to exploit this.
-- Itzik Ben-Gan 2001
November 4, 2016 at 11:36 am
SSIS Build Number 2796; Ver Major 10, Minor 50.
Having the same issues as
pchelptx (12/4/2015)
- no data in tables and the errors below
---------------Get all connections-----------------------------------
---------------Get all connections-----------------------------------
------------------------Get all variable details-------------------------------------
------------------------Get all variable details-------------------------------------
------------------------Get all parameter details-------------------------------------
------------------------Get all parameter details-------------------------------------
----------------Get precedence constraint details------------------------------
Msg 537, Level 16, State 5, Procedure SSIS_GetPackageDetails, Line 614
Invalid length parameter passed to the LEFT or SUBSTRING function.
The statement has been terminated.
Warning! The maximum key length is 900 bytes. The index 'NCIX_TblPrecedenceConstraint' has maximum length of 2000 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'NCIX_TblPrecedenceConstraint1' has maximum length of 1000 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'NCIX_TblPrecedenceConstraint1' has maximum length of 1000 bytes. For some combination of large values, the insert/update operation will fail.
----------------Get precedence constraint details------------------------------
----------------Get all Control flow tasks details------------------------------
----------------Get all data flow tasks details------------------------------
---------- Insert Script task details-----------------------
November 4, 2016 at 12:11 pm
7036golf (11/4/2016)
Having the same issues aspchelptx (12/4/2015)
- no data in tables and the errors below
---------------Get all connections-----------------------------------
---------------Get all connections-----------------------------------
------------------------Get all variable details-------------------------------------
------------------------Get all variable details-------------------------------------
------------------------Get all parameter details-------------------------------------
------------------------Get all parameter details-------------------------------------
----------------Get precedence constraint details------------------------------
Msg 537, Level 16, State 5, Procedure SSIS_GetPackageDetails, Line 614
Invalid length parameter passed to the LEFT or SUBSTRING function.
The statement has been terminated.
Warning! The maximum key length is 900 bytes. The index 'NCIX_TblPrecedenceConstraint' has maximum length of 2000 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'NCIX_TblPrecedenceConstraint1' has maximum length of 1000 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'NCIX_TblPrecedenceConstraint1' has maximum length of 1000 bytes. For some combination of large values, the insert/update operation will fail.
----------------Get precedence constraint details------------------------------
----------------Get all Control flow tasks details------------------------------
----------------Get all data flow tasks details------------------------------
---------- Insert Script task details-----------------------
What's your SSIS version?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
November 4, 2016 at 12:40 pm
SSIS Build Number 2796; Ver Major 10, Minor 50.
November 4, 2016 at 12:44 pm
7036golf (11/4/2016)
SSIS Build Number 2796; Ver Major 10, Minor 50.
Which is 2008, I think. The code was built for 2012, as has been mentioned in earlier comments.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
November 4, 2016 at 12:48 pm
right, there are 5 pages of comments, on which one?.... the information like this should be stated in the posted article itself as it is important to know (pre-requisites)
November 4, 2016 at 12:55 pm
7036golf (11/4/2016)
right, there are 5 pages of comments, on which one?.... the information like this should be stated in the posted article itself as it is important to know (pre-requisites)
I fully agree with you. I only know because I have been following the comments since the article was published.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
November 4, 2016 at 12:59 pm
thank you is there any way to fix code for 2008? if this just a one joint...
November 4, 2016 at 1:09 pm
7036golf (11/4/2016)
thank you is there any way to fix code for 2008? if this just a one joint...
From memory, there was quite a big change in file formats between 2008 and 2012, so I don't think that there will be any quick fixes.
Maybe some of the other 2008 posters have done some development to get this working?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
November 23, 2016 at 1:56 pm
it may seem trivial but can you post your Excel pivot report?
December 27, 2022 at 3:28 pm
Any chance this is going to get updated to read the Project connections file as well as the dtsx file?
Also, did you ever post the sample pivot, or provide instructions on how to create it?
Thanks!
August 7, 2023 at 1:04 pm
Great code! I have one questions as it seems the code works only for earlie version for the SSIS. Could you please advise me what has to be modified to be working with 2019 SSIS. Now most of the columns are ""empty and Im struggling what to modify to obtain their data (script tasks, TblDerivedTaskDetails, etc.)
Thank you and for your time!
Best regards
Viewing 14 posts - 31 through 43 (of 43 total)
You must be logged in to reply to this topic. Login to reply