July 29, 2010 at 12:41 am
I have a SQL Server Agent job that runs a SSIS package via the File System rather than Integration Services, as the server I'm running the package on doesn't have Integration Services installed. The package was deployed to the same server as the SQL Server Agent.
When I try to run the package, I get the following error:
Executed as user: HNEAHS\AppDev. ...sion 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:21:06 PM Warning: 2010-07-29 16:21:18.50 Code: 0xC0048000 Source: dtf Get Theatre Room Data dtf Get Theatre Room Data (DTS.Pipeline) Description: The registry key "SOFTWARE\Classes\CLSID\{DE50D3C7-41AF-4804-9247-CF1DEB147971}\DTSInfo" cannot be opened. End Warning Warning: 2010-07-29 16:21:18.50 Code: 0x8004801E Source: dtf Get Theatre Room Data dtf Get Theatre Room Data (DTS.Pipeline) Description: Cannot find the "CurrentVersion" value for component {DE50D3C7-41AF-4804-9247-CF1DEB147971}. The CurrentVersion value for the component cannot be located. This error occurs if the component has not set its registry information to contain a CurrentVersion value in the DTSInfo section. This message occurs during component development, or when the component is used in a package, if the component is no... The package execution fa... The step failed.
Does anyone have any ideas? I don't have any ownership over the server, and I suspect the owners don't want to install Integration Services on it - hence why I'm running the package via the File system.
November 17, 2011 at 3:18 am
You can't invoke a SSIS package on a server that has no SSIS installed on it. If you look at the log in your post, you'll see it's trying to reference a SSIS class in the registry. Since your server isn't running SSIS it's not a big surprise it cannot find these components.
I would suggest you schedule the package on the SSIS server. Not under SSIS, but connect to the database engine on that server and proceed as you would on the server without SSIS.
Otherwise install SSIS on the database server.
November 17, 2011 at 3:23 am
Good answer, but note that you have answered a question which is more than a year old 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 17, 2011 at 3:26 am
Yep.
I noticed when I allready had posted the answer.
I looked at the last login instead of the original post date.
Txs anayway ...
September 19, 2016 at 1:36 pm
Haha, it was helpful either way.... all the way into 2016 😛
November 29, 2016 at 4:25 am
This was removed by the editor as SPAM
January 22, 2020 at 8:30 pm
Until 2019 too!
July 9, 2020 at 9:41 pm
Helpful in 2020 too. Thank you!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply