<div>
Hi,<br />
where have you stored your SSIS packages? On the file system or in MSDB?<br />
Thanks.<br />
Rainer
</div>


Hi,
where have you stored your SSIS packages? On the file system or in MSDB?
Thanks.
Rainer

<div>
CRXIuser2005, do you still need help with this question?
</div>


CRXIuser2005, do you still need help with this question?

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have SQL JOBS that run my SSIS Packages each night.<br />
<br />
I have a FIX to one of my packages that needs to be deployed tonight and the normal SQL JOB that runs the normal package, runs at 7pm each night.<br />
<br />
Question: Can the SSIS Package that contains a small FIX, be deployed AT THE SAME TIME as the normal SSIS Package is &quot;running&quot;?<br />
<br />
We may NOT be able to &quot;disable&quot; the SQL JOB in time to prevent the 7pm running and so this is why I'm wondering.<br />
<br />
SQL SERVER 2008 is our system.<br />
<br />
Thanks
</div>
</div>


Experts,

I have SQL JOBS that run my SSIS Packages each night.

I have a FIX to one of my packages that needs to be deployed tonight and the normal SQL JOB that runs the normal package, runs at 7pm each night.

Question: Can the SSIS Package that contains a small FIX, be deployed AT THE SAME TIME as the normal SSIS Package is "running"?

We may NOT be able to "disable" the SQL JOB in time to prevent the 7pm running and so this is why I'm wondering.

SQL SERVER 2008 is our system.

Thanks

Can an SSIS Package be deployed at the SAME TIME as when its' SQL JOB is running the same SSIS Pkg?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.