Community forum

Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
Offline Brad C.  
#1 Posted : Thursday, March 14, 2019 1:35:09 PM(UTC)
Brad C.

Rank: Paid support

Joined: 8/23/2016(UTC)
Posts: 32
United States
Location: Eau Claire, WI

Thanks: 2 times
Was thanked: 7 time(s) in 7 post(s)
Is there a way to dynamically assign a connection for which a job uses?

We have a database that provides us a list of our active clients. We query that list and loop through each one and generate a PDF document using an SSRS task. This all works better than I could have even imagined, using VisualCron.

But, now we want to take it a step further and begin posting each of the 95 documents to the appropriate FTP location. 95% of them are using our internal FTP server and can be merely copied from their created location, into a UNC path that we would be able to determine through another database query.

For those that have their own FTP site, we would need to dynamically choose the proper connection, or supply connection information from the same database query.

Thoughts or ideas?

Edited by moderator Sunday, March 31, 2019 6:43:17 PM(UTC)  | Reason: Not specified

Offline Support  
#2 Posted : Sunday, March 31, 2019 6:43:05 PM(UTC)

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 10,958

Thanks: 840 times
Was thanked: 417 time(s) in 395 post(s)
Theoretically yes. You could VisualCron loop through a list with separate info about connection address, username and password and use Variables inside Connection.
Please like VisualCron on facebook!
Users browsing this topic
Guest (2)
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Scroll to Top