Preserving query when resetting Input Data credentials

Hi Folks,

Please feel free to direct me to the solution if this is already out there. My searches yielded thousands of hits but I could not zero in on my particular issue.

I have an existing workflow where the user password expired and I need to reset. Once I set up the DCM connection, the existing query in the Input Data tool is lost. I must either recover the query by some means or preserve it in the Input Data tool. I tried to copy / paste row 7 of the options; however, this only partially gets the SQL statement (seems to be limited on the number of characters fetched) and I am missing details from the WHERE clause.

Does anyone know how to get to the query for an expired Input Data tool?

Thanks in advance.

Input

Database Connection

Accepted answers

apathetichell

Use a text input and then map your query via dynamic input in-db or batch macro. To extract your full query though you can open your workflow in notepad and it should be there.

All comments

apathetichell

Use a text input and then map your query via dynamic input in-db or batch macro. To extract your full query though you can open your workflow in notepad and it should be there.

cjaneczko

You can see your queries under the workflow Dependencies. On the next screen that pops up click on the link at the top that says "Show Individual Tools". This entire table can be copied and pasted into excel. Then copy the queries (Ctrl + A then Ctrl + C) you want to recreate and paste them back into the Input tools.

mosesperry

Thanks a million. For some reason I thought the file would be encrypted so I didn't even try opening in Notepad. Query is there in full.

Much appreciated.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703