asked on

SSIS integration package - Data Flow

I am trying to upload an excel spreadsheet source to one table in sql 2008 standard databse.
i have truncated the table first in control flow, gone for data flow to update spreadsheet.

i received the error on one datatype, not able insert. please steps i have taken and spreadsheet source.

I am new at this and trying to do some of the tutorials as well, any suggestions greatly appreciated.

Error at Data Flow Task [pinvrep08 [57]]: The column "account_type" can't be inserted because the conversion between types DT_R8 and DT_I4 is not supported.

Error at Data Flow Task [SSIS.Pipeline]: "component "pinvrep08" (57)" failed validation and returned validation status "VS_ISBROKEN".

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)
AccountHierachy.xls Upload-to-SQL-Destintation.docx

ASKER CERTIFIED SOLUTION

tigin44

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

vdr1620

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

vdr1620

If you are trying to learn, I would suggest you use Import/Export Wizard in Sql server and do all the changes required and then at the end check the box and save it as SSIS package.. You can later, open it using visual studio and see the Design

Hope this helps !!