July 14, 2008 at 4:17 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 this piece of SQL Server would be missing. This is SQL 2005 STD ED with SP2 installed.
July 14, 2008 at 4:18 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:26 pm
SSIS cannot be clustered, but making some adjustments, it might be possible according to this: http://msdn.microsoft.com/en-us/library/ms345193.aspx
Maninder
www.dbanation.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply