SSIS package for Excel file

• kshatriya24

  SSC Eights!

  Points: 887

  More actions

  December 23, 2010 at 9:15 am

  #148027

  I'm trying to create tab in excel file (which is store on network). I'm getting following message , I verified file is not locked by any user.

  [Execute SQL Task] Error: Executing the query "CREATE TABLE `testtt` ( `case` VARCHAR(10), `case1` VARCHAR(50) ) " failed with the following error: "Cannot modify the design of table 'testtt'. It is in a read-only database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  Any suggestion ??

• Chrissy321

  SSCoach

  Points: 15763

  More actions

  December 23, 2010 at 2:21 pm

  #1266070

  Can you add the tab manually?

  Try moving the file local to eliminate ony network permission issues.

  See this:

  http://samuelhaddad.com/2009/03/31/overwriting-an-excel-file-destination-using-ssis/