SSIS Packages invoke from SQL AGent job from different SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS Packages invoke from SQL AGent job from...

SSIS Packages invoke from SQL AGent job from different SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

Kishore-132325

Posted Monday, January 28, 2013 6:57 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, January 28, 2013 7:46 AM
Points: 290, Visits: 112

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

Post #1412409

opc.three

Posted Monday, January 28, 2013 12:17 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:55 PM
Points: 6,720, Visits: 11,759

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1412599

« Prev Topic | Next Topic »

Permissions