Search results for query: *

The following insert query took ~8 mins on 1 million rows, going from an SQL table to another SQL table on a linked server: INSERT INTO [LinkedServer].[LinkedDatabase].[dbo].[LinkedTable] SELECT * FROM [LocalDatabase].[dbo].[LocalTable] However, creating an SSIS package and specifying 'Fast...

Got it! This is the command-line syntax: "C:\Program Files\GnuPG\gpg.exe" --passphrase "My passphrase" -o "C:\MyFile.txt" -d "C:\MyFile.pgp" Here is a VBScript example: Option Explicit Dim bWaitOnReturn: bWaitOnReturn = True Dim iWindowStyle: iWindowStyle = 7 'Minimized; active window stays...

Got it! This is the command-line syntax: "C:\Program Files\GnuPG\gpg.exe" --passphrase "My passphrase" -o "C:\MyFile.txt" -d "C:\MyFile.pgp" Here is a VBScript example: Option Explicit Dim bWaitOnReturn: bWaitOnReturn = True Dim iWindowStyle: iWindowStyle = 7 'Minimized; active window stays...

I'm trying to decrypt a GPG/PGP file using GPG via the command line. This works: "C:\Program Files\GnuPG\gpg.exe" -o "C:\MyFile.txt" -d "C:\MyEncryptedFile.pgp" However the command-window prompts me for my passphrase. I plan on scripting this and calling an InputBox to prompt for the...

I got it to output to a file like so: "C:\Program Files\GNU\GnuPG\gpg.exe" -d "C:\MiFile.pgp" > "C:\MyFile.txt" Now the only piece of the puzzle is passing the passphrase as a parameter via command-line.

Yeah I suppose it is more appropriately a GPG question, though I'm not sure if there's a forum for that? However my thought was that if anyone had implemented it via command-line they'd do so via either VBScript or a DOS batch file, and since I'm doing the former this seemed the place to post...

I have a PGP-encrypted file which I download and decrypt on my machine (currently via the GPG Windows GUI). Call the file 'MyFile.gpg'. I want to automate the decryption of this file. However I can't seem to locate a reference detailing the command-line syntax necessary, though I did find the...

I've installed OpenSSH successfully, and it works fine for my user account (Domain Administrators group). However when I add a new Domain User, then add this to the OpenSSH 'passwd' file, login via SFTP client fails. If I add this user to the Domain Administrators group their SFTP login works...

I'm on 64-bit and I've found that the old MSComDlg.CommonDialog object can only be invoked under 32-bit. I can use the Word dialog but of course that requires installing Word, and creating the Word.Application object is slow. What I'd like to know is how (or if) I can invoke a file-open/browse...

There is a secure FTP site I connect to (using FileZilla client). Many months ago I clicked 'Always trust' on their certificate in the FileZilla interface; now I can no longer connect. I know the site still works because I can connect from another (XP) machine...on that machine I get the...

I solved this by the way, in case anyone's interested: Option Explicit Dim oExpSchTsk Set oExpSchTsk = New cExport_Scheduled_Tasks oExpSchTsk.Export_Scheduled_Tasks Set oExpSchTsk = Nothing WScript.Quit Class cExport_Scheduled_Tasks '<Initialization> Private Array_XML_Aggregate 'as String...

I can access the clipboard via the IE object, but this requires interaction. Since I have AutoIt installed I found that I can write to the clipboard like this: Private Sub Write_to_Clipboard(sClipboard_Text) Dim oAutoIt 'as Object = AutoItX3.Control Set oAutoIt =...

You have to put [User] in brackets as well: Insert Into [User] ([User First Name],... As mentioned, 'User' is a reserved word for Access SQL.

I'm trying to list the names of the Scheduled Tasks on my 64-bit Win 2008 server so I can export them. I discovered that I can easily export them as XML files, all at once (in which case they can't be imported on another machine), or individually by name with the following command-line syntax...

dm4ever: THANK YOU! That is exactly correct, and I never would've thought to try it that way. tsuji: thanks, I knew my implementation was a bit sloppy (and the utilization is even uglier); that will help me clean it up a bit. skie: the dictionary object looks quite useful and a bit clearer...

Thanks. With the tips provided I see I can export them all via the command-line (and thus via a script or batch file) with the following command: schtasks /Query /XML >[desired output path & XML filename] Or I can specify a single task with the /TN switch. I'll play around with importing...

I'm trying to use a string array as a property. I can read the LBound/UBound so it seems the array is loading properly during the 'Let', and the 'Get' is working for the boundary functions, but I can't seem to access the values. Any ideas? Set oMyClass = New cArrayTest With oMyClass...

I have several Scheduled Tasks on one of my Vista machines, and I will soon be migrating to another machine. What I'd like to do is export (or copy) all of these tasks via script to some shared location, then import them on the new machine. I've looked in Windows\Tasks but don't see my tasks...

I need to convert a Unicode file to ASCII; I found a simple VBScript to do this (see below). However, I only want to make this conversion if the source file is Unicode. How can I test the file to see if it's Unicode? Thanks. Here's the script: Option Explicit Dim sSourceFileName 'as String...

I have a DTS package stored in a structured storage file. When I call the package from the command-line on one (actually several) machine on my network it executes normally. We just added a new machine to the network, configured it, but when I run the package I get the following error: Error...