SSIS Package documentor

Question

SSIS Package documentor

Viewing 14 posts - 31 through 43 (of 43 total)

You must be logged in to reply to this topic. Login to reply

pchelptx SSC Veteran Points: 243 More actions · Answer 1

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.

Alan Burstein SSC Guru Points: 61141 More actions · Answer 2

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.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

7036golf SSC Veteran Points: 276 More actions · Answer 3

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-----------------------

Phil Parkin SSC Guru Points: 246939 More actions · Answer 4

7036golf (11/4/2016)
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-----------------------

What's your SSIS version?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

7036golf SSC Veteran Points: 276 More actions · Answer 5

7036golf

SSC Veteran

Points: 276

November 4, 2016 at 12:40 pm

#1910705

SSIS Build Number 2796; Ver Major 10, Minor 50.

Phil Parkin SSC Guru Points: 246939 More actions · Answer 6

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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

7036golf SSC Veteran Points: 276 More actions · Answer 7

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)

Phil Parkin SSC Guru Points: 246939 More actions · Answer 8

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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

7036golf SSC Veteran Points: 276 More actions · Answer 9

thank you is there any way to fix code for 2008? if this just a one joint...

Phil Parkin SSC Guru Points: 246939 More actions · Answer 10

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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

milnerphil 83146 SSC Journeyman Points: 93 More actions · Answer 11

it may seem trivial but can you post your Excel pivot report?

ycxsky Newbie Points: 1 More actions · Answer 12

Hi Divya,

Thanks for sharing this great article!!! It really helps me!

While I run your script, there is no result for below columns in TblControlFlowDetails
SqlTaskQry
ExecPkgTaskQry
ScriptTaskQry

Could you please guide me how to get the value?

kabaker55 Newbie Points: 1 More actions · Answer 13

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!

h4ckff Newbie Points: 2 More actions · Answer 14

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