Wednesday 15 February 2012

Issue Loading Flat File in SSIS - Invalid Character on Last Line -



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