April 29, 2009 at 10:34 am
Ok I'm getting the following errors. Can any of you think another reason why I would be getting these? Other than needing an Enterprise version of SSIS that is. I'm currently running SQL 2005 Standard SP3 on my server.
Running a DTS package through SSIS
Started: 4:20:00 PM
Error: 2009-04-08 16:20:54.31
Code: 0xC0012024
Source: REFRESH_RPM_TABLES_PRE_CLEANUP
Description: The task "REFRESH_RPM_TABLES_PRE_CLEANUP" cannot run on this edition of Integration Services. It requires a higher level edition.
End Error
Derived Column
Started: 4:29:56 PM
Error: 2009-04-14 16:30:16.75
Code: 0xC00470FE
Source: DTSTask_DTSDataPumpTask_KP DTS.Pipeline
Description: The product level is insufficient for component "Derived Column Category" (1504).
End Error
Lookup
Error: 2009-04-14 16:30:16.75
Code: 0xC00470FE
Source: DTSTask_DTSDataPumpTask_KP DTS.Pipeline
Description: The product level is insufficient for component "Lookup cm_codes" (1513).
End Error
Script
Error: 2009-04-14 16:30:16.75
Code: 0xC00470FE
Source: DTSTask_DTSDataPumpTask_KP DTS.Pipeline
Description: The product level is insufficient for component "Script Ref Num Web Service" (1540).
End Error
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
April 29, 2009 at 10:51 am
Is this relevant:
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 29, 2009 at 12:44 pm
Well I read the article but I'm not sure I understand it. How do you set a package to run "in process" I've seen in/out of process when talking about linked servers but that's it so far.
We are running our SSIS package using DTEXEC and a package saved to the file system. We are successfully running simple packages but anything beyond the very basic does not seem to work.
Thanks for all of the help
Kenneth
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
April 29, 2009 at 1:09 pm
Kenneth Fisher (4/29/2009)
Well I read the article but I'm not sure I understand it. How do you set a package to run "in process" I've seen in/out of process when talking about linked servers but that's it so far.We are running our SSIS package using DTEXEC and a package saved to the file system. We are successfully running simple packages but anything beyond the very basic does not seem to work.
Thanks for all of the help
Kenneth
Kenneth,
Jeffrey may have some code he may share with you so you could avoid these edition related problems because all your errors are valid but may be avoided with code.
Kind regards,
Gift Peddie
April 29, 2009 at 4:30 pm
Not sure why you are getting these errors - I have no problems running those types of processes using Standard Edition.
Could it be that you don't have the standard version of Integration Services installed on that server? Could you have installed the SQL Server 2005 Express Advanced Services instead?
Only thing I can think of...at the moment.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 1, 2009 at 9:03 am
Its a full install of SQL Server Standard, including SSIS. Could it be the method we are using to call the package? IE DTEXEC instead of using a job?
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply