cache transform

• coool_sweet

  SSCommitted

  Points: 1892

  More actions

  June 14, 2017 at 8:09 am

  #338179

  I am getting following error:

  TITLE: Microsoft Visual Studio
  ------------------------------

  System.Runtime.InteropServices.COMException (0x80004005): The file had bad version and flags information. The file is damaged or not a SSIS-produced raw data file.

     at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerCache100.GetFileColumns(String bstrFileName)
     at Microsoft.DataTransformationServices.Design.CacheConnectionManagerForm.buttonRefresh_Click(Object sender, EventArgs e)

  ------------------------------
  BUTTONS:

  also I m getting data from flat file, after executing its giving me error:

  [Cache Transform [2]] Error: The Cache Transform failed to write the cache to file "D:\product170520.xt". The hresult is 0xC020205B.

  but this is my source file, why it is writing in source file.
  also while using cache transform ,it will create file on the fly , or it should be there in folder already?

  thanks

  OK
  ------------------------------

• Phil Parkin

  SSC Guru

  Points: 245813

  More actions

  June 14, 2017 at 10:23 am

  #1946804

  coool_sweet - Wednesday, June 14, 2017 8:09 AM

  I am getting following error:

  TITLE: Microsoft Visual Studio
  ------------------------------

  System.Runtime.InteropServices.COMException (0x80004005): The file had bad version and flags information. The file is damaged or not a SSIS-produced raw data file.

     at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerCache100.GetFileColumns(String bstrFileName)
     at Microsoft.DataTransformationServices.Design.CacheConnectionManagerForm.buttonRefresh_Click(Object sender, EventArgs e)

  ------------------------------
  BUTTONS:

  also I m getting data from flat file, after executing its giving me error:

  [Cache Transform [2]] Error: The Cache Transform failed to write the cache to file "D:\product170520.xt". The hresult is 0xC020205B.

  but this is my source file, why it is writing in source file.
  also while using cache transform ,it will create file on the fly , or it should be there in folder already?

  thanks

  OK
  ------------------------------

  Apologies if this is obvious, but have you double-checked the config of the cache transform to ensure that it contains no direct or indirect references to your source file?

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.