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 |
|
descsh
Starting Member
5 Posts |
 Posted - 2008-05-15 : 21:30:35
|
| Hi,can anyone help on this? I have the created to read in excel file data. I used the Excel source task and configured it. I configured the task to read in a file call transaction.xls and there is only 1 sheet in the workbook called transaction as well. When I configured the connection manager, I can see the data preview. And I saved it. When I execute it, it gave me the error below. Really have no idea what caused the problem. for additional info, we do not have the microsoft office installed in this server, only ms sql. Do I need to install the ms office in the server in order to have this work?Error Msg:SSIS package "ImportTranx.dtsx" starting.Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.Error: 0xC020801C at Data Flow Task, Source - Transaction$ [1]: The AcquireConnection method call to the connection manager "SourceConnectionExcel" failed with error code 0xC0202009.Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "Source - Transaction$" (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 "ImportTranx.dtsx" finished: Success. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 22:16:52
|
| How and where did you run the package? Did you create package on sql server machine? Where did you save the package? |
 |
|
|
descsh
Starting Member
5 Posts |
Posted - 2008-05-15 : 22:49:06
|
quote:
Originally posted by rmiao
How and where did you run the package? Did you create package on sql server machine? Where did you save the package?
I manual executed the tasks in the Visual Studio in the SQL server. The debug screen shown me the error msg. Yes. The package was created in the SQL server machine. The package was save in the server as well. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 23:13:55
|
| Where is excel file then? Does sql service account have permission to read it? |
|
|
|
descsh
Starting Member
5 Posts |
Posted - 2008-05-16 : 03:01:28
|
quote:
Originally posted by rmiao
Where is excel file then? Does sql service account have permission to read it?
The excel file is seating in the same SQL server. Yes. The SQL services have permission to read the file. I had done the manual import using the import function in the SQL Server Management Studio. It was successful. But when It comes to SSIS, I hit this error? could it be the problem which the server do not have MS Office installed which somehow it fail to call some of the dll? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 16:03:09
|
| Export/Import Wizard is also part of SSIS. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-17 : 17:19:42
|
| >> could it be the problem which the server do not have MS Office installed which somehow it fail to call some of the dll? Where did you run package manually? |
|
|
|
descsh
Starting Member
5 Posts |
Posted - 2008-05-20 : 00:16:09
|
| I ran it using debug mode in the SSIS in the SQL Server. |
|
|
|
|
|
|
Failed to import Excel Data