December 18, 2008 at 1:52 am
I have tried unsuccessfully to import data from excel into a SQL table using SSIS.
Steps Taken:
1) Added Data Flow Task
2) Added Excel Source
3) Added SQL Server Destination
4) OLE DB connection manager: new browsed to excel file path \\servername\folder\exel.xls (First row has column names checked)
Data access mode: Table or view
Name of Excel sheet: Sheet1$
5) SQL Server Destination: New - Entered Server Name + Windows Authentication + Database Name - Connection Test OK
6) Use table or view: I have tried importing to existing empty 'Products' Table + creating a new table 'Part'
Mappings all appear good.
7) Right Click in Data Flow Pane select 'Execute Task'
Error:
SSIS package "Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Error: 0xC020801C at Data Flow Task, Excel Source [1]: 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.
Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "Excel Source" (1) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "Package.dtsx" finished: Success.
Anything obvious jump out?
Many Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
December 18, 2008 at 9:03 am
First guess is that the Excel file is open.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 18, 2008 at 10:35 am
Thanks Jack, pretty sure it wasn't but been wrong before 🙂
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
December 18, 2008 at 11:45 am
And this isn't running on a 64bit box? We've hit issues before with the provider, needing to not execute under 64bit 🙁
Steve.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply