CODEWITHSUNDEEP
c#excelssisssis-2012
user1810575
user1810575

Reputation: 831

SSIS Excel connection challenges

I was able to complete my task with out any problem if excel file is open

If Excel file is open then no error import task works perfectly.

If Excel file is closed, i get below error

Failed to acquire connection "Excel Connection Manager 4". Connection may not be configured correctly or you may not have the right permissions on this connection.

Any thoughts on how to handle

Upvotes: 0

Views: 2643

Answers (1)

Rahul Sharma
Rahul Sharma

Reputation: 453

Try to specify these extra parameters in your Excel connection string: 
  Mode=Read; ReadOnly=True
 Provider=Microsoft.Jet.OLEDB.4.0;Data Source=filename; Extended Properties="EXCEL 8.0;HDR=YES; Mode=Read; ReadOnly =True;"

and try this also :

It sounds like there is an Excel connection string in your package which is not valid for some reason. Try:

  1. Opening your package (.DTSX file) in an XML editor (I use XML Marker - its nice and simple)
  2. Search for the 'Dynamic Excel Connection Manager' entry.
  3. See if you can identify the connection string in there.
  4. Fix it it and save

Upvotes: 1

Related Questions