InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 21:07:30 GMT20http://www.sqlservercentral.com/Forums/Topic805272-391-1.aspxSet the delay validation property to true to stop it checking the connection file before the variable is properly loaded. I can't remember if it's on the connection manager or the actual component that needs it.Fri, 23 Oct 2009 07:25:23 GMTP Joneshttp://www.sqlservercentral.com/Forums/Topic805272-391-1.aspxWithout being able to see the package you've created, I can't be certain what the problem may be. Have you confirmed that the Excel file you're using is not corrupt (trying opening it in Excel)?I created a simple package (using BIDs on a 32-bit machine) that contains an Excel Source & OLE DB Destination, Excel Connection Manager, and an SSIS variable that stores the full path to the Excel file. The package runs successfully. Here are the steps I followed. I hope this is helpful in resolving the error you're getting:1. Added Excel Source.2. Added Excel Connection Manager, clicked Edit, and entered the full file path in the Excel file path box (C:\Work\Excel Folder\TestBook97.xls). Saved changes.3. Configured the Excel Source to point to the connection manager.4. Added a string variable to the package, confirmed that the variable scope was Package, and filled in the variable value (C:\Work\Excel Folder\TestBook97.xls).5. Added an expression to the Excel Connection Manager, to set value of the ExcelFilePath property using the string variable.6. Connected the Source to the Destination.Thu, 22 Oct 2009 17:40:58 GMTsabottahttp://www.sqlservercentral.com/Forums/Topic805272-391-1.aspxThe path is long one with many spaces like t:\clients\projects\blah blah\report1It is set to Excel 97-2003.Mon, 19 Oct 2009 20:38:09 GMTdavidlcrookshttp://www.sqlservercentral.com/Forums/Topic805272-391-1.aspxWhat is the file path (full path) that you're storing in the variable? And, is this an Excel '97 file or a later version?Mon, 19 Oct 2009 20:16:33 GMTsabottahttp://www.sqlservercentral.com/Forums/Topic805272-391-1.aspxNo, I had thought about something like that after I posted the question.Now, I get an error to Please provide a file extension in the Excel file path... I did try to brute force it but then it said it was an invalid file name.Thanks for the reply!Mon, 19 Oct 2009 20:01:00 GMTdavidlcrookshttp://www.sqlservercentral.com/Forums/Topic805272-391-1.aspxDid you use an Expression to configure the ExcelFilePath property value of the Excel Connection Manager:@[<variable name>]Mon, 19 Oct 2009 16:40:50 GMTsabottahttp://www.sqlservercentral.com/Forums/Topic805272-391-1.aspxI guess this is the right place for this question?I am trying to pass a variable (filename with path) to a package to send that variable to SSIS as an Excel Source. I have a variable defined as a string and a default value where an Excel file is located (verified). When I change the Data Access Mode to table name or variable and then select the variable it throws the error that opening the rowset failed. Any ideas? TIA!David L. CrooksMon, 19 Oct 2009 14:27:30 GMTdavidlcrooks