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.
| Author |
Topic |
|
nord
Posting Yak Master
126 Posts |
 Posted - 2012-03-28 : 00:40:42
|
| Hi,everyoneI 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,everyoneI 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 MVPhttp://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 formatis there a way to make it fixed length instead at least?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
txt file(separatot tab) to tabe