SSIS Package Tranfer Help...

• rocky_498

  SSCertifiable

  Points: 6532

  More actions

  January 28, 2014 at 8:09 pm

  #303513

  Hi Guys,

  I have one question, I Schedule my SSIS package to Copy All Directry file using "File System Task" (All are SSIS Packages) from one server to other as a back up,

  I just notice after i copy from one server to other server All Flat File Source or Destination "Text Qualifier" Option change to something

  e.g "c_090_9489" and so on. Is anyone can help me to fix this issue.

  Thank You in advance.

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  January 29, 2014 at 12:32 am

  #1684158

  Sometimes when copying packages strange things happen in the XML code.

  For example, <none> can be replaced with _x003C_none_x003E_.

  _x003C_none_x003E_ FlatFile Error in SSIS

  Maybe this issue is related?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP