I am working on accessing data from our Sybase Databases to pull data over and place it in our MS SQL Server. We may not be able to install the needed Sybase driver and datasources on the SQL Server. If that is the case, I am not sure if this alternative would work, but wanted to ask the question.
We have a file server available. So if we load the Sybase driver and datasources on this file server, then I deploy the packages to a loacation on the file server, would I be able use SQL Agent on the SQL Server (located on another server) to run then package and would the datasources be accessed off the fileserver? The problem is we can add the datasources and driver to the file server but not an instance of SQL.
I have not tried this before and wanted to see if it is possible. If not is there another solution that could be used?
View Complete Post