December 12, 2007 at 1:57 pm
I am running SqlAgent with a domain user account and has all the necessary rights. In the design mode package executes fine.
I get the error written below.
Any help will be appreciated.
Thanks!
G.
Executed as user: .sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:31:30 PM Error: 2007-12-12 14:33:01.91 Code: 0xC004706C Source: DataFlow Copy Excel Data to Temp Table DTS.Pipeline Description: Component "component "Perform Data Type Conversion" (272)" could not be created and returned error code 0x80070005. Make sure that the component is registered correctly. End Error Error: 2007-12-12 14:33:27.92 Code: 0xC0048021 Source: DataFlow Copy Excel Data to Temp Table Perform Data Type Conversion [272] Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Data Conversion;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0". End Error Error: 2007-12-12 14:33:27.92 Code: 0x... The package execution fa... The step failed.
December 13, 2007 at 2:19 pm
Its resolved never minnd. SSIS was not installed on the sql server.
Thanks!
G.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply