My requirement is as follows:
Dot net code calls a DTS package.
DTS package has a dynamic variable saying the input file given is xyz.xls in
some path on the drive, and it is mentioned to take data from Sheet1 of the
xls
However during code execution, the xls is renamed as say, abc.xls.
I am also changing the value of the variable with the new name of the file
However, the DTS fails execution saying it cannot find the rows to transform.
In actual, it is still searching for the file with name xyz.xls and not
taking the new file name for execution
--
Kumar.A.P.P
http://techaid.wordpress.com/

Traditional COM based DTS? (like SQL 2000)

If so, you have to use a COM wrapper to get at the bits. One way is to
export the DTS package (or a high level package that calls the rest of the
bits in another package) as VB and compile using VS 6.0. You can then create
a COM wrapper.

Rather than continuing the complexity, how about code?
http://www.15seconds.com/issue/030909.htm

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

*************************************************
"Kumar.A.P.P" <KumarAPP (AT) discussions (DOT) microsoft.com> wrote