• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • Last Modified:

SSIS Excel Open File

I have a package that I used to execute via DTS in SQL Server 2000, that I am attempting to move to SSIS in SQL Server 2005.

The package takes the contents of an Excel Spreadsheet and copies it to a SQL Server table.

In DTS, I was able to copy the excel spreadsheet to a SQL table even if someone had the spreadsheet open.

In SSIS, if someone has the spreadsheet open, I get an error message and I cannot copy it to the SQL table.

This spreadsheet is open pretty much all day, but I need to copy the information multiple times per day.

Is there a way to copy from Excel to a SQL Server table even if the Excel Spreadsheet is open?
1 Solution
Reza RadConsultant, TrainerCommented:
you can use a file system task , and copy your excel file to another path first
and then read data from this new path and fill the table with it.
yonbretAuthor Commented:
Work around is an acceptable solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now