January 28, 2013 at 6:57 am
Hello - Below is my setup :
1. 1 SQL Server 2012 [ destination server ]
2. 1 SQL Server 2008 [ source server ]
3. 1 File server - I have SSIS installed on this File server but no SQL Server installed. My SSIS Packages are hosted on this server and they will pull data from my source SQL server DB Tables and dump into Destination SQL server DB Tables.
I want to invoke the SSIS package on File server from a SQL Job hosted on destination server.
Is this possible and if so how ?
Please suggest.
Thanks
Kishore
January 28, 2013 at 12:17 pm
Kishore-132325 (1/28/2013)
Hello - Below is my setup :1. 1 SQL Server 2012 [ destination server ]
2. 1 SQL Server 2008 [ source server ]
3. 1 File server - I have SSIS installed on this File server but no SQL Server installed. My SSIS Packages are hosted on this server and they will pull data from my source SQL server DB Tables and dump into Destination SQL server DB Tables.
I want to invoke the SSIS package on File server from a SQL Job hosted on destination server.
Is this possible and if so how ?
Please suggest.
Thanks
Kishore
What do you mean you have SSIS installed but no SQL Server? Ignoring the physical location of the .dtsx file which is not important within which server (i.e. CPU and RAM) do you want the package to actually be executing? The file server or the destination server?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply