August 29, 2008 at 7:38 am
Using SSIS to import Excel spreadsheet into SQL Server 2005. Created the package variable for PathAndFileName. Execute package. First Excel file is imported, but 2nd Excel file is not. Reads and imports First Excel file twice. Because there are 2 Excel files in the directory.
After following the MSDN 345182 How To, received a connection error.
Any suggestions?
February 6, 2017 at 4:37 am
Create a string variable and call it currentFile.
In the For Each Loop editor go to Variable Mappings, in the Variable field select User::currentFile and in the Index field enter 0
Now modify the Excel Connection Manager properties. select Expressions, in the Property Field select ExcelFilePath, in the Expression field click the ellipsis [...] and drag and drop User:currentFile into the expression window. Click okay to everything and you are done.
February 6, 2017 at 7:41 am
delaine.gocke - Friday, August 29, 2008 7:38 AMAny suggestions?
BAAA-HAAA!!! Yeah... Do it in T-SQL instead.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy