Thanks Lowell, I didn't need it to do any clean up so i was just curious on how do get the fuzzy number between the two addresses. I actually...

Yup, you called it. I think I found were the problem lies in the code.

mrtrich99 (11/1/2010)

---

i have a package with a data flow task that has an OLE DB source and OLE DB Destination. In the OLE DB Source is a SQL query...

No, i'm just using an "Execute SQL Task" and the sql queries are in there.

I think i found the root of the problem. The package i have is inserting records into the table where the update needs to happen prior to the update....

Hi Cozy,

Thanks for doing that, I wish I could buy you a couple beers right about now. Now I see how the variable is used in the expression. ...

mrtrich99 (2/9/2009)

---

CozyRoc (2/9/2009)

It fails because it tries to validate the data flow task, which will be setup during execution. Right-click on your data flow task and change DelayValidation property to...

CozyRoc (2/9/2009)

It fails because it tries to validate the data flow task, which will be setup during execution. Right-click on your data flow task and change DelayValidation property to true....

It fails because it tries to validate the data flow task, which will be setup during execution. Right-click on your data flow task and change DelayValidation property to true. Give...

that test.xls file does have only 1 sheet. i thought that was the problem too, but it gives me the same error as files with multiple sheets.

I want to...

The attached the "ExcelError" file is the error code I get if I only have the User::Variable as the Connection String in the expression.

When I don't use the...

Ed (2/5/2009)

---

Well... I've learned something here. You can't really disable a task at runtime. What you can do is put an expression in the workflow precedence (the arrow)...

Thanks Ed for the ReadWriteVariables, the Script Task now...

Ed (2/5/2009)

---

As G squared indicated, there is a UseDirectoryIfExists property you can set to True in the FileSystem Task. As to why your code isn't working - two things...

I have UseDirectoryIfExists set to True, but it errors out as it tries to create it. If I set it to False it gives me an "X" saying it...