Import Data error from Excel

[4:07 PM] Derar al Fares

===================================



An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. (SQL Server Import and Export Wizard)



===================================



A generic error occurred in GDI+. (System.Drawing)



------------------------------

Program Location:



at System.Drawing.Graphics.MeasureCharacterRanges(String text, Font font, RectangleF layoutRect, StringFormat stringFormat)

at System.Windows.Forms.LinkLabel.EnsureRun(Graphics g)

at System.Windows.Forms.LinkLabel.OnPaint(PaintEventArgs e)

at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)

at System.Windows.Forms.Control.WmPaint(Message& m)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.Label.WndProc(Message& m)

at System.Windows.Forms.LinkLabel.WndProc(Message& msg)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)



[4:07 PM] Derar al Fares

===================================



Could not instantiate the destination component.



Error 0xc004706c: SSIS.Pipeline: Component ", clsid {B5D38974-BE31-4ABA-85AB-FADAA58E773A}" could not be created and returned error code 0x80070008 "Not enough storage is available to process this command.". Make sure that the component is registered correctly.





Error 0xc0048021: [107]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".

(SQL Server Import and Export Wizard)



===================================



Exception from HRESULT: 0xC0048021 (Microsoft.SqlServer.DTSPipelineWrap)



------------------------------

Program Location:



at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ProvideComponentProperties()

at Microsoft.SqlServer.Dts.DtsWizard.Execute.SetDestConnection(Exception& ex, TransformInfo ti)



[4:08 PM] Derar al Fares

- Setting Destination Connection (Error)

Messages

Error 0xc004706c: SSIS.Pipeline: Component ", clsid {B5D38974-BE31-4ABA-85AB-FADAA58E773A}" could not be created and returned error code 0x80070008 "Not enough storage is available to process this command.". Make sure that the component is registered correctly.

(SQL Server Import and Export Wizard)


Error 0xc0048021: [107]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".

(SQL Server Import and Export Wizard)


Exception from HRESULT: 0xC0048021 (Microsoft.SqlServer.DTSPipelineWrap)

Hi Olaf,

Ok, noted with thanks.

can you check another error getting, when trying to import?