Hello All,

I'm trying to go from a Dynamic Properties Task (or an ActiveX Script
Task) to an MS Excel 97-2000 Connection in a DTS Package. It doesn't
matter what I use: On Completion, On Success, or On Failure. I
continue to get the error message listed in the Subject line of this
post. Is there any way around this?

My package starts of with an ActiveX Script Task setting the global
variable used for the file name to empty quotes (for use in the next
step if I click cancel). Then I go to an Open File Dialog Task
(downloaded from SQLDTS.com) to select a file. Then on to one of the
2 tasks listed above. The Dynamic Properties task sets the file name
for the MS Excel connection with the global variable. The ActiveX
Script task first tests the file name global variable to see if it is
"" and fails the task if it is (and the whole package stops executing
if it is). If it actually has a file name in there, it will cut out
part of the file name and store it in a Date global variable and then
succeeds the task. And then on to the MS Excel connection. But it
doesn't look like I can get to the Excel connection from either of
these two tasks.

Any help on this matter will be greatly appreciated,

Conan Kelly

Hello Conan Kelly" CTBarbarin at msn dot com,

You do not go from Task to connection, you go from task to task in the workflow.
Is the Excel connection part of a task or just stood by itself?


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

I figured it out.

I was trying to from my Dyn. Prop/ActiveX Scr. Task to my Excel Connection without yet having a Trans. Data Task between my Excel
connection and my destination connection.

Thanks for all the help


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote