sql server - SSIS Flat File Source Text Qualifier being ignored -


i using ssis insert data flat file database.

i have created data flow task that. using flat file source , ado net destination insert data.

below how setting looks flat file source.

flat file settings

below how "columns" tab like

columnstab

this works fine when run using bids , data inserted database. works dtexec.exe when run locally.

now, problem executing package on server using dtexec.exe. on server, data inserted text qualifier (double quotes) given totally ignored while inserting data database. same works totally fine when run locally. have attached image below how stored in database.

data inserted database

i have checked sql server version , ssis version locally , on remote server , both same.

what can problem? can help?

within flat file connection manager, within "advanced" option, should given view of different parameters each field. see each field have name, columndelimiter, bunch of faded out fields , datatype , choice if text qualified or not.

in there, should specify column(s) wish determined text qualified setting textqualified option true.

notice false in example


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -