|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Generate DTSRun commandline syntaxI have an app that runs selected DTS packages when a trigger file arrives.
They need to define what DTS package to run by entering the encrypted command-line syntax, right now that is done by them running DTSRunUI.exe and copping the generated syntax and pasting it in my app. I would rather not make them do that because DTSRunUI.exe is not very intuitive for someone that does not know SQL Server. Is there a way to generate an encrypted command-line syntax using c#? Thanks Dan Reber Hi
As far as I know this is not possible; effectively you are asking for the key to the encryption algorithm. John Show quote "Daniel Reber" <dreber@nospam.com> wrote in message news:uvUVnlVtFHA.2880@TK2MSFTNGP12.phx.gbl... >I have an app that runs selected DTS packages when a trigger file arrives. > They need to define what DTS package to run by entering the encrypted > command-line syntax, right now that is done by them running DTSRunUI.exe > and > copping the generated syntax and pasting it in my app. I would rather not > make them do that because DTSRunUI.exe is not very intuitive for someone > that does not know SQL Server. Is there a way to generate an encrypted > command-line syntax using c#? > > Thanks > > Dan Reber > > No, not the key, but method that is exposed in c# that will generate it for
me. I know that you can execute a package from c# and I was just working how extensive the object model for DTS is exposed. I don't think that I can though, I have not found any reference to it. Thanks Dan Show quote "John Bell" <jbellnewspo***@hotmail.com> wrote in message news:%235dt5MWtFHA.3596@TK2MSFTNGP15.phx.gbl... > Hi > > As far as I know this is not possible; effectively you are asking for the > key to the encryption algorithm. > > John > > "Daniel Reber" <dreber@nospam.com> wrote in message > news:uvUVnlVtFHA.2880@TK2MSFTNGP12.phx.gbl... > >I have an app that runs selected DTS packages when a trigger file arrives. > > They need to define what DTS package to run by entering the encrypted > > command-line syntax, right now that is done by them running DTSRunUI.exe > > and > > copping the generated syntax and pasting it in my app. I would rather not > > make them do that because DTSRunUI.exe is not very intuitive for someone > > that does not know SQL Server. Is there a way to generate an encrypted > > command-line syntax using c#? > > > > Thanks > > > > Dan Reber > > > > > > Do you *need the ecryption, do the packages have passwords or are the
package names sensative ? Show quote "Daniel Reber" <dreber@nospam.com> wrote in message news:uvUVnlVtFHA.2880@TK2MSFTNGP12.phx.gbl... >I have an app that runs selected DTS packages when a trigger file arrives. > They need to define what DTS package to run by entering the encrypted > command-line syntax, right now that is done by them running DTSRunUI.exe > and > copping the generated syntax and pasting it in my app. I would rather not > make them do that because DTSRunUI.exe is not very intuitive for someone > that does not know SQL Server. Is there a way to generate an encrypted > command-line syntax using c#? > > Thanks > > Dan Reber > > We don't want the username/password exposed in a file that all of the
command-lines will be stored. I think that we found a way around it by listing all of the packages and allowing the user to select the one that they want.The username/password will by encrypted by my app and stored to file along with the package that they want to execute. From there we can create the non-encrypted commandline syntax and send it to dtsrun.exe. Dan Show quote "David J. Cartwright" <davidcartwri***@hotmail.com> wrote in message news:uaN4USWtFHA.3640@tk2msftngp13.phx.gbl... > Do you *need the ecryption, do the packages have passwords or are the > package names sensative ? > > "Daniel Reber" <dreber@nospam.com> wrote in message > news:uvUVnlVtFHA.2880@TK2MSFTNGP12.phx.gbl... > >I have an app that runs selected DTS packages when a trigger file arrives. > > They need to define what DTS package to run by entering the encrypted > > command-line syntax, right now that is done by them running DTSRunUI.exe > > and > > copping the generated syntax and pasting it in my app. I would rather not > > make them do that because DTSRunUI.exe is not very intuitive for someone > > that does not know SQL Server. Is there a way to generate an encrypted > > command-line syntax using c#? > > > > Thanks > > > > Dan Reber > > > > > > Dan,
Construct your dtsrun command line and add /!Y switch at the end. This will generate an encrypted command line without executing. This is the only way to get encryption going. We use this approach in conjunction with xp_cdmshell extended stored procedure so to not expose logins in files. You can still catch xp_cdmshell sql statement with the profiler, but one would need sa rights to do that. Keep in mind that there is a limit to the length of dos command line in general. The encrypted dtsrun command line is about three times longer and you may hit this limit when you have too many parameters. We did. The step to resolve this limitation would be keeping all parameters in a file, encrypted if necessary. Then you would need to supply only the file location. Ilya Show quote "Daniel Reber" <dreber@nospam.com> wrote in message news:uvUVnlVtFHA.2880@TK2MSFTNGP12.phx.gbl... > I have an app that runs selected DTS packages when a trigger file arrives. > They need to define what DTS package to run by entering the encrypted > command-line syntax, right now that is done by them running DTSRunUI.exe and > copping the generated syntax and pasting it in my app. I would rather not > make them do that because DTSRunUI.exe is not very intuitive for someone > that does not know SQL Server. Is there a way to generate an encrypted > command-line syntax using c#? > > Thanks > > Dan Reber > > Thanks Ilya, I was just about to reply stating the I found the /!Y parameter
but you beat me to it. Dan Show quote "Ilya Margolin" <ilya_no_spam_@unapen.com> wrote in message news:exuZRB6tFHA.2072@TK2MSFTNGP14.phx.gbl... > Dan, > > Construct your dtsrun command line and add /!Y switch at the end. This will > generate an encrypted command line without executing. This is the only way > to get encryption going. We use this approach in conjunction with > xp_cdmshell extended stored procedure so to not expose logins in files. You > can still catch xp_cdmshell sql statement with the profiler, but one would > need sa rights to do that. > > Keep in mind that there is a limit to the length of dos command line in > general. The encrypted dtsrun command line is about three times longer and > you may hit this limit when you have too many parameters. We did. The step > to resolve this limitation would be keeping all parameters in a file, > encrypted if necessary. Then you would need to supply only the file > location. > > Ilya > > "Daniel Reber" <dreber@nospam.com> wrote in message > news:uvUVnlVtFHA.2880@TK2MSFTNGP12.phx.gbl... > > I have an app that runs selected DTS packages when a trigger file arrives. > > They need to define what DTS package to run by entering the encrypted > > command-line syntax, right now that is done by them running DTSRunUI.exe > and > > copping the generated syntax and pasting it in my app. I would rather not > > make them do that because DTSRunUI.exe is not very intuitive for someone > > that does not know SQL Server. Is there a way to generate an encrypted > > command-line syntax using c#? > > > > Thanks > > > > Dan Reber > > > > > >  |
|||||||||||||||||||||||
Other interesting topics