What exactly are you trying to do? Can you put the link to the msdn help here please.
Thanks
Sutha
|||well i have a number of excel files and i want to use them in a loop so as to do calculations and load a table. when i use one file the process is ok, but when i use the steps described in that link
http://msdn2.microsoft.com/en-us/library/ms345182.aspx
i get errors.
thank u in advance
|||You are not trying to do this on a 64 Bit by any chance?
"You may not be able to connect to as many data sources from a package executing in 64-bit mode as you can from a package executing in 32-bit mode. Some .NET Framework Data Providers and native OLE DB providers may not be available in 64-bit versions. For example, the Microsoft OLE DB Provider for Jet, which connects to Access databases and Excel spreadsheets, is not available in a 64-bit version." (http://msdn2.microsoft.com/en-us/library/ms141766.aspx)
Thanks
Sutha
|||no an i get the following message
TITLE: Microsoft Visual Studio
Error at Package3 [Connection manager "SourceConnectionExcel"]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Pilote ISAM introuvable.".
Error at Data Flow Task [Excel Source [1]]: The AcquireConnection method call to the connection manager "SourceConnectionExcel" failed with error code 0xC0202009.
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)
BUTTONS:
OK
|||Are you getting this error message on "To loop through Excel files by using the Foreach File enumerator" OR "To loop through Excel tables by using the Foreach ADO.NET Schema Rowset enumerator".
I worked through the first one (To loop through Excel files by using the Foreach File enumerator) and it worked without any issues.
Thanks
Sutha
|||i worked with To loop through Excel files by using the Foreach File enumerator
I don't know :)
Thanks
|||well i tryied with the following way? i read a file with the import/export wizard, i followed the instructions of the link, i loaded the files in a separate table and it worked. the problem is with the excel source in the data flow. am i using the wrong compnent. because i want to read directly the files and not to load them in a table. am i not supposed to use "excel source"?
thnxs
|||I have a working example that I have done can be download from here.
Uses c:\Temp as source directory for Foreach Loop
Thank
Sutha
|||
and how can i use the script in order to use a data flow task in order to use the data in other transformations?
thnxs
|||All I have done in that example, is just to get the xls files in c:\temp, assign each file name and print the variable to a message box.
you still have to do data flow task.
Thanks
Sutha
