February 6, 2015 at 2:33 am
Its Friday so I am doing some blue sky thinking...
I have just started a new role where we have about 40 customers who use our core product. The core of the application code and database are reasonably well managed in terms of code base and version roll-out, however added value services such as reports and SSIS jobs and the associated database objects such as views and sprocs tend to get written on site and we have no copies back at the office and no control over what gets changed, and therefore no version control. I can Remote desktop into each site and run the scripts to generate text files for all the database objects, copy all of these and the external artefacts (SSIS, SSRS and Crystal Reports .RPT files) back to our file servers and then put them into a mercurial/subversion/TFS repository, but I don't really want to do it by hand each week for 40 customers.
Is there a way to connect to a remote server using RDP from SSIS 2008. I can set a scheduled task on the remote servers to prepare the files for me, I just need to control the collection from my end: alternatively I have to set up an SSIS job on each client to prep the files and ftp them to me, but that means changes on the client end which I would prefer to avoid.
February 6, 2015 at 6:21 am
Are all these machines on the same domain, or in domains with trusts?
I don't think you really want an RDP as that's an interactive session and with SSIS you're running in non interactive mode really. What you could try doing (depending on the connectivity to these machines) is running a powershell command locally that invokes an action (powershell, ssis, bat whatever) on the remote machine, where that remote script maybe ftp's the file back to you. These can be called using IP, and possibly require a firewall change if all the servers are outside your domain.
Steve.
February 6, 2015 at 3:44 pm
different domains, I don't want the hassle of getting changes made to DNS and NATS settings; the company a bit neadethal when it comes to automation. (how come so many companies who specialise in producing integrated solutions for their clients are are so bad at integrating their own workflows!!)
I think I will have to pursue the multiple PUSH option rather than my preferred PULL
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply