Home Forums SQL Server 2008 SQL Server Newbies SSIS: Not able to transfer a FLAT FILE Data to Database. Please help RE: SSIS: Not able to transfer a FLAT FILE Data to Database. Please help

  • Think its the column delimiter

    When on the columns tab of the source connector you will see an option for column delimiter - its a drop down. But you can click in there and press the spoace bar. This will then work for your data.

    However seperating columns with a space is very likely to cause problems later on. Its much better to use | or # or something else taht will not occur in the data set.

    E

    🙂