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/
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
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/
txt file(separatot tab) to tabe
Posted - 03/28/2012 : 00:40:42
