SSIS Package to Excel Makes Visual Studio stop working

Posted on 2012-08-22
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?
Question by:DavidLumpkin
    LVL 14

    Expert Comment

    by:nishant joshi
    is your excel having too much data?
    try this.
    1)kept column name only 1 record in excel
    2)create ssis package with 1 record excel
    3)before execution put excel the original and check..


    Author Comment

    My spreadsheet only had 44 rows.  There were some formulas in other columns, so I removed them and had the same results.
    I then created a new spreadsheet and entered the following:

    A1            fpartno
    A2            fvendno
    B1            001960
    B2            9800-46000-1000

    My first column here shows the location that I put the actual data (second column).

    I saved this pristine spreadsheet and tried again.  (I did check, as before, the first row contained headers).  

    Got the same results, SSIS restarts and my package did not save.  I can't get past this.

    Accepted Solution

    No one is able to answer my question and your site says I have abandoned questions and will not let me ask another.

    Author Closing Comment

    So far this site has not helped much.  No one can answer this question and I can't ask another because your site says I've abandoned it.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now