txt file(separatot tab) to tabe

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

txt file(separatot tab) to tabe

Author

Topic

nord
Posting Yak Master

126 Posts

Posted - 2012-03-28 : 00:40:42

Hi,everyone
I have ssis: txt file to table and txt file from the customer have separator "tab",how i can replace 'tab' to ';'
thanks

rajarajan
Starting Member

48 Posts

Posted - 2012-03-28 : 01:02:48

http://www.sql-server-performance.com/2007/import-text-files-ssis/1

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2012-03-28 : 14:09:12

what if ; is in the actual text


 Nord;{tab}Norford{tab}SSSIS;BI;Apache;Hadoop{tab}

Houston we got a problem

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-28 : 14:43:04

quote:
Originally posted by nord

Hi,everyone
I have ssis: txt file to table and txt file from the customer have separator "tab",how i can replace 'tab' to ';'
thanks

you mean replace the entire delimiter inside text file?
whats the need of that?
if delimiter is consistent you can configure text file connection manager to use tab as delimiter itself

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

nord
Posting Yak Master

126 Posts

Posted - 2012-03-29 : 09:18:00

Hi,
I mean have txt.file one time with delimiter=tab,second=; and i need insert informations into table(ssis),with delimiter=; i don't have problem but wit 'tab' yes ,what i can do with this?
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-29 : 12:42:43

why is delimiter varying?
any etl tool wont be able to dynamically change connection properties to vary delimiter format
is there a way to make it fixed length instead at least?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources