We help IT Professionals succeed at work.
Get Started

SSIS Package to Excel Makes Visual Studio stop working

Last Modified: 2012-09-15
Unusual error with no leads on how to solve it.
I am running SQL Server 2008 on a virtual server with Windows Server 20008 R2.

On my previous SQL 2000 server, I accessed Excel data through Opendatasource.  Apparently that no longer works.  Most people suggest SSIS.

I created a SSIS package and added a Data Flow Task.  I added a connection manager to the Excel Spreadsheet which has 10 or 12 columns.  I connected to the correct tab on the spreadsheet.  Looking at it in Table or view, I see all the columns.  Changed Data Access mode to SQL Command and typed in

SELECT fvendno, fpartno, 'ODS' AS PullType

When I click on Parse Query the message says, "The SQL Statement was successfully parsed."  I click OK.

Now, if I click Preview or Columns, the screen greys out.  When I click any where on the screen I get a box that says "Microsoft Visual Studio 2008 has stopped working."  

I've tested this several times with the same results.  Removing the added string column makes no difference.  There is no indication of what is causing the problem.

Any ideas?
Watch Question
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE