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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
November 23, 2016 at 1:56 pm
it may seem trivial but can you post your Excel pivot report?
Viewing 12 posts - 31 through 41 (of 41 total)
You must be logged in to reply to this topic. Login to reply