Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
POI writes formula to Excel, but formula's value is not calculated
I've written Java POI code to open an Excel file and set a cell's formula by using "setCellFormula()". The code compiles and correctly updates the field's formula, but the value is not calculated. For example, a cell's value might be set to "=2+2" by calling cell.setCellFormula("2+2")... -
dynamic db connections?
Hi, I would like to have an SSIS package that connects to a database A (OLE datasource) and reads from a table called "controlling" a varchar value for connecting to another database "B" (connection string info). Then the SSIS package would query database B and proceed with any stuff that...- Ben3026
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
