Web
Site
Search
Home
Agenda
Links
Bloggers
Over PASS Nederland
User benefits
Geregistreerd... en dan?
Sponsoring
Artikelen
Cursussen en certificering
SQL Server 2000
SQL Server 2005
Examenrecensies
Archief nieuwsbrieven
2005
Nieuwsbrief 1 / 09-10-2005
2006
Nieuwsbrief 2 / 16-01-2006
Nieuwsbrief 3 / 11-03-2006
Nieuwsbrief 4 / 11-04-2006
Nieuwsbrief 5 / 08-05-2006
Nieuwsbrief 6 / 18-06-2006
Nieuwsbrief 7 / 27-08-2006
Nieuwsbrief 8 / 20-10-2006
Nieuwsbrief 9 / 22-12-2006
2007
Nieuwsbrief 10 / 04-02-2007
Nieuwsbrief 11 / 05-03-2007
Nieuwsbrief 12 / 02-04-2007
Nieuwsbrief 13 / 01-05-2007
Nieuwsbrief 14 / 01-06-2007
Nieuwsbrief 15 / 02-09-2007
Nieuwsbrief 16 / 04-10-2007
Nieuwsbrief 17 / 05-11-2007
Nieuwsbrief 18 / 06-12-2007
2008
Nieuwsbrief 19 / 12-01-2008
Nieuwsbrief 20 / 14-02-2008
Nieuwsbrief 21 / 02-05-2008
Nieuwsbrief 22 / 16-06-2008
Nieuwsbrief 23 / 01-08-2008
Nieuwsbrief 24 / 13-11-2008
Nieuwsbrief 25 / 01-12-2008
2009
Nieuwsbrief 26 / 07-02-2009
Nieuwsbrief 27 / 09-03-2009
Nieuwsbrief 28 / 01-04-2009
Nieuwsbrief 29 / 04-06-2009
Nieuwsbrief 30 / 02-09-2009
Nieuwsbrief 31 / 06-10-2009
Nieuwsbrief 32 / 07-11-2009
Nieuwsbrief 33 / 04-12-2009
Forum
onze sponsors
Forum
Login
|
Register
Forum
Unanswered
Active Topics
Forums
Search
Forums
>
Forums
>
Business Intelligence
Subject: Remote SSIS execution with indirect config file
Prev
Next
You are not authorized to post a reply.
Author
Messages
Oldest First
Newest First
David Bytheway
Posts:1
10-06-2010 12:59:10
Alert
I am attempting to run an SSIS Package (via a SQL Server Agent Job) on another server and pass indirect configuration-file information but the wrong configuration file is used.
Step 1: Execute batchfile on the calling server setting a System-variable to identify the configuration file location on the called server (SSIS package uses indirect configuration) as follows:
rem Set System-variable for config file location
SETX Out_SSIS_ConfigFile \\remote_servername\C$\required_configfile.dtsConfig -m
Step 2: In the batchfile, use osql to launch the SSIS via a SQL Server Agent Job on the remote server SQL server
"\\remote_servername\C$\Program Files\Microsoft SQL Server\100\Tools\Binn\osql.exe" -E -Sremote_servername -i\\remote_servername\C$\Out_StartJob.txt
Note 1: Out_StartJob.txt contains:
USE MSDB
GO
EXEC sp_start_job @job_name = 'SSIS_Call_Jobname', @server_name = 'remote_server_SQL_Server_Instance_name'
GO
Note 2: 'SSIS_Call_Jobname' has a single step of type 'SQL Server Integration Services Package' which executes the package dtsx file (in the file system of the remote server of course). 'Configuration' and 'Command File' tabs are empty.
Result:
The SSIS runs OK but uses the WRONG configuration file. It would appear that it is referencing the System-variable of the same name (Out_SSIS_ConfigFile) on the remote server rather than that of the calling server to locate the config file. I guess this is logical, since osql is being run on the remote server.
Any idea how I can pass the correct information to the job, since, as far as I am aware, indirect configuration requires a system- not user-variable. Perhaps a different approach to remotely launching the SSIS, with or without indirect configuration, would be preferable. At present I'm stuck!
You are not authorized to post a reply.
Algemeen
--Forum regels
PASS Nederland
--Aankondigingen
--Bijeenkomsten
--PASS Nederland Algemeen
Forums
--DBA
--Ontwikkelen
--Business Intelligence
--Metadata (SIG)
--Performance (SIG)
--High Availability (SIG)
--XML (SIG)
--Algemeen
SQL Server
Forums
>
Forums
>
Business Intelligence
> Remote SSIS execution with indirect config file
ActiveForums 3.6
Copyright (c) 2012 PASS Nederland
Privacy Statement
Terms Of Use