Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
 Posted - 2013-11-05 : 10:11:25
|
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
52326 Posts |
Posted - 2013-11-05 : 12:48:52
|
| seems like you corrupted the connection information of the excel seeing the error message.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2013-11-05 : 13:13:40
|
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. |
|
|
|
|
|
|
Excel source with SELECT stmt