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

  • Also, if you are importing free form text, I find it quite helpful to have a text delimiter, such as a double quote, in addition to a column delimiter. Even though the design of the database wasn't meant to include data that has commas, single quotes, or other special characters in it, doesn't mean that a user won't try to shove them in there.

    -G