List of all dtsx files used in [Integration Services Catalog] - I need help with the SELECT statement

Question

List of all dtsx files used in [Integration Services Catalog] - I need help with the SELECT statement

Viewing 5 posts - 31 through 34 (of 34 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

Sue_H identified the other part of your issue(permissions to fiddle with the registry) : you must run Powershell as Administrator...right click...run as Administrator.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mw_sql_developer SSCoach Points: 19445 More actions · Answer 2

Lowell - Wednesday, July 26, 2017 8:52 AM
Sue_H identified the other part of your issue(permissions to fiddle with the registry) : you must run Powershell as Administrator...right click...run as Administrator.

Didnt work, gives the same error.. Hey lets take a break. A person from networking meets me at 11.30. Lets see whether I am really an administrator for this machine ( I think he had given me admin rights )
Never mind...
Lowell:
In a previous post, you had given me some advice on how to get a missing DLL from the GAC. Turns out I managed to get the DLL from the folder... ( See pic below )
So I am asssuming I should take the one in the folder starting with 13.0.0..... ( assuming that is the latest )
Next Question: So in VS2012 I just place the DLL in any folder and then use the "ADD Reference" ? That should do it right ?

mw_sql_developer SSCoach Points: 19445 More actions · Answer 3

mw112009 - Wednesday, July 26, 2017 9:14 AM
Lowell - Wednesday, July 26, 2017 8:52 AM
Sue_H identified the other part of your issue(permissions to fiddle with the registry) : you must run Powershell as Administrator...right click...run as Administrator.
Didnt work, gives the same error.. Hey lets take a break. A person from networking meets me at 11.30. Lets see whether I am really an administrator for this machine ( I think he had given me admin rights )
Never mind...
Lowell:
In a previous post, you had given me some advice on how to get a missing DLL from the GAC. Turns out I managed to get the DLL from the folder... ( See pic below )
So I am asssuming I should take the one in the folder starting with 13.0.0..... ( assuming that is the latest )
Next Question: So in VS2012 I just place the DLL in any folder and then use the "ADD Reference" ? That should do it right ?

mw_sql_developer SSCoach Points: 19445 More actions · Answer 4

OK, Team, Thanks for the help.
Everything worked peacefully.
Like Lowell and Sue mentioned, I did not have Admin Rights on my machine. Once that was given the script runs.

I changed the script ( powershell ) to save it as a "zip" file rather than an ispac file.
That way I can unzip it right away ( without having to rename )
I was able to do my search ( The purpose was to search through all dtsx files to see whether there was a some code that was referring a to a particular field that was named as SSN or
SocialSecurityNumber or .... )

So I am done! Thax, Lets close the case.
I also added a question to STACKOVERFLOW.com asking me to give direction to do the same in C# ( So far no one has shown interest )
So for now POWERSHELL seems like the way to go ... Anyone knows a good resource for learning powershell ?

Sue_H SSC Guru Points: 90860 More actions · Answer 5

mw112009 - Wednesday, August 2, 2017 8:31 AM
So for now POWERSHELL seems like the way to go ... Anyone knows a good resource for learning powershell ?

There are a ton of different resources for learning Powershell - what's good depends somewhat on how you learn.

You could look at the Stairway to Powershell series on this site:
Stairway to Powershell

Microsoft Virtual Academy has an introduction to Powershell:
Getting Started with Microsoft PowerShell

MSSQLTips has a couple of introductory articles - you could start here:
Introduction to Windows PowerShell for the SQL Server DBA Part 1

Lots of things like that which you can search for.

Sue