using an ~ as the delim type

Hot Topic

Slow report generation
Derived Shape - Replacing a column with itself.
Management Studio and Mangement Studio Express on the same machine
How to get DateTime type parameter in the reports which based on AS Data source
Access Script Task
SCD component in SQL2005
C# Algorithm/ libraries
SSIS will not start after SQL Server 2005 SP1 upgrade
SSIS Tutorial Lesson 1: Debug Error
Configure RS in sql express

SQL Server

Set in where clause - how to?
updating XML data column through datasets and sqlxmladapter?
CREATE ASSEMBLY using assembly binary?!?!
Discard Rows in a flat file
SSIS packages in registry?
Show multiple order records in single row
Database Mirroring with multiple websites
How to handle printing big batches of reports
How to use DTS run time DTSexec in express/workgroup version of sql server 2005
best datatype to save password

using an ~ as the delim type

Hi all,

Need some advice on how to handle SSIS imports of txt files that use the ~ as the delimiter.

Rows are handled OK just the seperation of the columns is the issue. The setup is from a vendor which has coded the extract routines to use this symbol (not sure what it is called, sorry!) as the the delimiter and other options are unavailable.

I have a solution working in Access using these same files however, I want to take advantage of the SQL 2005 functionality.

Many thanks,

M

Answer this question

using an ~ as the delim type

  • resyuz

    Thank you for your suggestion.

    I've tried this however, the '~' symbol is not listed as an option and I can't see how you can specify others than what is listed.

    I'll consider other options however, being able to specify the delimiter is preferable.

    Cheers

  • John Wilkie

    Hello.

    In your "Flat File Connection" under "Connection Managers" select "Columns" and you can set your delimiter. Under "Advanced" you can even set different delimiters for different fields, if you want

    Hope this helps



  • Chris White

    Wait a minute, I think I have it.

    I forced in the ~ as you suggested instead of selececting it from the drop-down list.

    Thanks for your assistance.

  • anonymizer

    The delimiters offered in the list are only the ones that are commonly used. You can type whatever you want as your delimiter and even combine printable with not printable characters by using provided ({CR}, {LF}, {t}, etc) markers.

  • using an ~ as the delim type
Answer this question