April 26, 2012 at 7:42 am
I have a simple environment consisting of two servers, one which runs SSIS and the other which hosts a SQL Server instance. My packages are deployed to the msdb package store on the database server and my single msdtssrvr.ini.xml on the SSIS server contains:
<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>DEVSQL1</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>
If I invoke my package thus:
dtexec /SQL SkeletonMain /Ser DEVSQL1
it runs without any problems, however if leave off the /Ser switch with the expectation that SSIS will pick this up from the msdtssrvr.ini.xml file, it bombs out stating that the package cannot be found.
I'm sure there is something really trivial I'm missing, can someone please point me in the right direction as to what I'm doing wrong.
Chris
April 29, 2012 at 11:45 pm
Did you restart the SSIS service?
MSDN says:
If the /Server option is omitted, the default local instance of SQL Server is assumed.
It's a bit vague what they mean with that.
Do you have other instances on your box?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 30, 2012 at 2:34 am
Hi Koen,
As is often the case when soliciting help from other people, forums etc, I found out what my my problem was shortly after posting this question, . . . and it turned out to be a very basic one at that :-(, in order to use a remote package store I needed the /DTS switch and NOT the /SQL one. Suffice to say my issue is now resolved.
Regards,
Chris
April 30, 2012 at 2:42 am
Allright, glad that the issue is resolved and thanks for posting back!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply