Databases
StackOverflow2013
Postsdbo
PORedeploying SSIS packages - Cache?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORedeploying SSIS packages - Cache?
    primarykey
    data
    text
    <p>We have noticed an issue recently that redeployed SSIS packages sometime don't seem to include the latest changes... When I search the dtsx using notepad I see the amended script in the code so the changes are definitely there. </p> <p>My assumption was that script components of SSIS packages are eventually compiled into an assembly somewhere in the process - this is quite likely since I would imagine C# code cannot run without something compiling it first. So in theory if these assemblies would then end up being cached and not immediately overwritten (for some reason) that would explain this issue. </p> <p>The only "evidence" that makes me think that my theory is correct is if I keep running the package at some point it suddenly shifts to the new code.</p> <p>However, so far I haven't found why and how this is happening, if is... Can anybody help?</p> <p><strong>UPDATE:</strong> MSDN says: "Unlike earlier versions where you could indicate whether the scripts were precompiled, all scripts are precompiled in SQL Server 2008 Integration Services (SSIS) and later versions." - If by <em>pre-compiled</em> they mean that instead of the actual package a pre-compiled version runs (I think this because the package itself does not seem to be compiled since the code is visible in Notepad) there must be a way to force the engine to overwrite the pre-compiled assembly... but how?</p> <p><strong>UPDATE:</strong> One of the four core components of SSIS is the <em>SQL ServerIntegration Services service</em>, which is a windows service. Apparently this service will cache component/task metadata so that the SSIS runtime engine can poll the cache to see what is installed, which may help speed up package load times. However, if the packages are stored in the file system (not in SQL Integration Services) and executed by Agent Jobs, the agent job will use the 64 bit version of DTEXEC to execute the packages. I haven't yet found evidence that any caching would be involved there, but there are certainly options to check a number of parameters in the validation phase of the execution, such as version numbers - may be for a reason.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USG Berdal
    1. USG Berdal
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PORedeploying SSIS packages - Cache?
      1. USIain Samuel McLean Elder
      1. VTFavorite
    2. VO
      singulars
      1. PORedeploying SSIS packages - Cache?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PORedeploying SSIS packages - Cache?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COJust to say we have the same exact issue here today. Restarting the agent nor the SQLSISS helps.
      singulars
      1. PORedeploying SSIS packages - Cache?
      1. USBoris Callens
    2. COWhat did the trick was adding and removing a column from a table involved. Clearly, this is not the way to go and we are certainly interested in the answer to this question
      singulars
      1. PORedeploying SSIS packages - Cache?
      1. USBoris Callens
    3. COAlso: I think the cache is stored somewhere on disk because it survived a server reboot
      singulars
      1. PORedeploying SSIS packages - Cache?
      1. USBoris Callens
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload