July 14, 2008 at 2:12 pm
I have a developer working on SSIS packages and needs the SQL Server Integration Service Started because his packages didn't run over the weekend. I looked and SQL Server Integration Service is not available to start from SQL Server Configuration Manager. How can I install this service? This is a clustered server and I don't want to screw anything up. I thought I did a complete installation but I'm not sure why that would be missing.
Thank you.
Patti
July 14, 2008 at 3:06 pm
Just to update this post, Here is the message that is received from the job history:
Message
Executed as user: TUSCDC\ATSAdmin. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:00 PM Error: 2008-07-10 20:00:03.70 Code: 0xC0029100 Source: Auto ActiveX Script Task Description: Function not found. End Error Error: 2008-07-10 20:00:03.70 Code: 0xC0024107 Source: Auto Description: There were errors during task validation. End Error Error: 2008-07-10 20:00:03.70 Code: 0xC00470FE Source: Employment Ads Transform DTS.Pipeline Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Employment CSV File" (55). End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:00:00 PM Finished: 8:00:03 PM Elapsed: 2.844 seconds. The package execution failed. The step failed.
July 14, 2008 at 6:24 pm
Patricia Johnson (7/14/2008)
Just to update this post, Here is the message that is received from the job history:Message
Executed as user: TUSCDC\ATSAdmin. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:00 PM Error: 2008-07-10 20:00:03.70 Code: 0xC0029100 Source: Auto ActiveX Script Task Description: Function not found. End Error Error: 2008-07-10 20:00:03.70 Code: 0xC0024107 Source: Auto Description: There were errors during task validation. End Error Error: 2008-07-10 20:00:03.70 Code: 0xC00470FE Source: Employment Ads Transform DTS.Pipeline Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Employment CSV File" (55). End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:00:00 PM Finished: 8:00:03 PM Elapsed: 2.844 seconds. The package execution failed. The step failed.
Run setup and tick the checkbox for installing SSIS only. That should not cause you any problems.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
July 14, 2008 at 9:29 pm
Thank you. I wasn't sure if SSIS was cluster aware. It wasn't configured that way but you were right, all I had to do was install Integration services and re-apply spk2 and everything was good. Thanks for lending your suggestion to help me out.
Patti
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply