SQL Server Performance Forum – Threads Archive

Reading a CELL without using Name Range

Is 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.
—
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
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
http://www.sqldts.com/default.aspx?t=6&s=101&i=243&p=1&a=0

]]>