[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SSIS Package to Excel Makes Visual Studio stop working

Posted on 2012-08-22
Medium Priority
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
  • 3
LVL 14

Expert Comment

by:nishant joshi
ID: 38323449
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

ID: 38326450
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

DavidLumpkin earned 0 total points
ID: 38384515
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

ID: 38401343
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


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

873 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