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: 246960

  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?

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin