It is possible to decrypt the name as I once found a utility written by a Russian dude which did it. It was a bit scrappy and errored but it did return the name correctly. Sadly I've lost it but I'll see if I can't hunt it down again and I'll post the link here if so.
Further to my last post, whils searching for DtsRunDec the decoder app , I found this thread on sqlforums. C at the end, the utility will decode the name for you without executing the package and put the decrypted run string into the cliboard which you can then paste out at will. Having tried it, it works perfectly. Obviously, names have been changed to protect the innocent!! Top marks to jamespua on sqlforums for such a handy tip.
The full documentation for DTSRun and it's switches is here. No kidding?! I tried using the arguments also and it does work.
Who knew that was right under our noses. Jake Shelton. You must be logged in to reply to this topic. Login to reply. June 27, at am Hi all, Does anyone know how to decrypt the name of a dts package from within a sql job. Any help most appreciated? Regards, Don. June 27, at pm Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data.
How to tell what SQL Server versions you are running. Resolving could not open a connection to SQL Server errors. Ways to compare and find differences for SQL Server tables and data.
Searching and finding a string value in all columns in a SQL Server table. View all my tips. Back To Top It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. I have taken over a SQL database. I am trying to figure out what a job is doing. Its command is:. Is there a way I can see what this string represents?
Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 8 years, 2 months ago.
0コメント