SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Excel source with SELECT stmt
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gbritton
Constraint Violating Yak Guru

416 Posts

Posted - 11/05/2013 :  10:11:25  Show Profile  Reply with Quote
I have a working package that uses an Excel source. I wanted to only select a few columns so I changed the task from Table to SQL Statement. Then, I used the query builder to build a query to just take the columns I wanted. When I tried to run this, however, it crashed with the error:

quote:

[EXC RiverMine Data [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.




Note that, the package worked fine before I added the select statement.

Worse yet, when I removed the SELECT statement and set the task back to Table, it still fails, even on other packages using the same source but with Table as input type! In fact, I had to close/relaunch BIDS to get rid of the error.

I double-checked my project preferences to ensure that 64-bit operation is disabled -- it is.

So....what can be the problem here? Is the Select statement option broken or is there some restriction I'm breaking?

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 11/05/2013 :  12:48:52  Show Profile  Reply with Quote
seems like you corrupted the connection information of the excel seeing the error message.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

gbritton
Constraint Violating Yak Guru

416 Posts

Posted - 11/05/2013 :  13:13:40  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

seems like you corrupted the connection information of the excel seeing the error message.



Indeed! And...I did it again and again (two or three times, relaunching BIDS in between). In fact, it's really easy to corrupt it. What I'd like to know is how to do what I want WITHOUT corrupting it. As it is, all I did is point and click my way using the query builder on a brand-new Excel connection.

Edited by - gbritton on 11/05/2013 13:22:06
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000