Issue Loading Flat File in SSIS - Invalid Character on Last Line -
i trying import flat file table in ssis throwing error because theres "sub" character on lastly line. how can around or remove it? please see screen shot below see see in notepad++. when remove it works fine.
any ideas?
thanks in advance,
craig
you need add together conditional split on info flow , route unusable rows out of destination.
reference-- (msdn) http://msdn.microsoft.com/query/dev10.query?appid=dev10idef1&l=en-us&k=k(sql12.dts.designer.conditionalsplittrans.f1)&rd=true
ssis flat-file
No comments:
Post a Comment