SQL Server Performance Forum – Threads Archive
Reading a CELL without using Name RangeIs there any way of reading the contain of a given cell from DTS. I can’t create a Name range as I don’t have control over the Excel
Don’t know what it’s like in DTS. Maybe you’ll find something on www.sqldts.com
But have a look at the Excel object model for Range (Enumeration (I believe it must be translated so, or Array()) in the online help. You don’t need names.
Microsoft SQL Server MVP
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)
I searched at sqldts but couldn’t find any.
I will look for Excel object model
Not sure whether this may help you
http://support.microsoft.com/kb/257819 Madhivanan Failing to plan is Planning to fail
This is seems to be good. But how can I edit the Globle variables