How to use Import Column Transformation in SSIS Package

In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to use Import Column Transformation in SSIS to load image files, text file, pdf file and all other formats to SQL Server Table.

This video is also used for SQL Server Integration Services (SSIS ) Interview Question " Which transformation can I use in SSIS to importimage files to a Table?"


How to use Import Column Transformation in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

2 comments:

  1. Please put your SQL variable script. I am getting some difficulty to implement it.
    TITLE: Microsoft Visual Studio
    ------------------------------

    Exception from HRESULT: 0xC0202009
    Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
    An OLE DB record is available. Source: "Microsoft OLE DB Driver for SQL Server" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.".
    An OLE DB record is available. Source: "Microsoft OLE DB Driver for SQL Server" Hresult: 0x80040E14 Description: "Incorrect syntax near the keyword 'FILE'.".



    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Please help me to solve this error

    ReplyDelete
  2. Exception from HRESULT: 0xC0202009
    Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
    An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.".
    An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Incorrect syntax near the keyword 'File'.".

    How Cann you resolve this errors?

    ReplyDelete