dbTalk Databases Forums  

SSIS - Using an ASCII character as column delimiters in Flat File Connection Manager

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS - Using an ASCII character as column delimiters in Flat File Connection Manager in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Hans
 
Posts: n/a

Default SSIS - Using an ASCII character as column delimiters in Flat File Connection Manager - 08-30-2005 , 10:30 AM






Does anybody know how to use any ASCII character as column delimiter in
SSIS Flat File Connection Manager?

I am trying to read from a flat file in which the ASCII character 0x1F
(unit separator) is used as column delimiter, but I don't know how to
enter that non-standard delimiter in the Flat File Connection Manager
Editor. I've tried a few things I coud think of, but without any luck.

Any ideas?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.