February 4, 2005 at 8:28 am
HELP.
i have a flat file that i down load from a vendor that goes to our ftp site. the file(csv) is encrypted and we have a decryption (.EXE) that we use to decrypt the file once its downloaded.
I would like to automate this process.
i know how to get the encrypted files from the ftp site to a folder on the network, but how do i decrypt this file in order to get it into my table.
thanks
[font="Comic Sans MS"][/font]It is what it is.
February 4, 2005 at 8:48 am
Add an "Execute ProcessTask" to your DTS package and in the proerties provide the name of you decryption EXE. Use workflow so that it runs after the FTP task is complete.
Can the EXE take params that determine the output location ? If yes, just have it output to the desired location, otehrwise add an "ActiveX Script Task" and use VBScript to move the decrypted file.
Final step is to add a a "Bulk Insert Task" to the package to load the decrypted text file to a SqlServer table.
February 4, 2005 at 10:37 am
thanks journey man,
the problem is that i need to automate this process and it needs to run at night. the problem i am getting is when i use the .exe, it opens a dialog box that i then have to specify both an input and output file. , select decrypt and then hit the close button before i can continue. even when i specify inout and output in the parameters
[font="Comic Sans MS"][/font]It is what it is.
February 4, 2005 at 12:12 pm
You're never going to be able to automate a process that requires user input to a GUI.
This is less of a SqlServer/DTS issue and more of a "make the EXE work in silent, non-interactive mode" issue. Do you have source code for the EXE, or is it 3rd party ?
February 4, 2005 at 1:27 pm
Third party.
[font="Comic Sans MS"][/font]It is what it is.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply