Community forum

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

Notification

Icon
Error

Options
View
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: 30
United States
Location: Eau Claire, WI

Thanks: 2 times
Was thanked: 6 time(s) in 6 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?
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.

Powered by YAF.NET | YAF.NET © 2003-2019, Yet Another Forum.NET
This page was generated in 0.128 seconds.
Scroll to Top