SSIS Text Qualifier Issue

• amanmeet.mehta 46966

  SSC Eights!

  Points: 859

  More actions

  January 3, 2013 at 12:11 pm

  #268169

  We are migrating an existing SQL 2000 DTS package To SSIS SQL 2008. The current package is comma delimited and has a text qualifier as ". In DTS the

  out put file which is generated correctly but the same is not generated when we run through SSIS.

  Can you please suggest what could be wrong?

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  January 3, 2013 at 3:40 pm

  #1573512

  Can you please post a sample line of data that DTS outputs as you like, and a sample of what SSIS outputs?

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato