OK, I did that with a VB scrip message box that has an OK and Cancel button but how to I cancel execution of the package if the user clicks...

Thanks, I found that. I also found this though it seems much more involved:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/62662/

Do you mean the datatypes?

Bump.

I don't know what to say it is bringing back all of the estimates.

Grant Fritchey (4/23/2010)

---

You can change the JOIN criteria something like this:

SELECT...

FROM Contractor INNER JOIN

...

It allows remote connections per the KB article here:

http://support.microsoft.com/kb/914277

Followed the instructions still no change.

That link is not an html link.

I do not see the database user that I created under the Security | Logins directory. I just see 'sa' and my AD account.

Jack Corbett (11/10/2009)

---

Can you post exactly what your need is? It looks like you want to select the 15 characters after a "/", is this correct? If your...

it probably is but i don't see what difference that would make if I gave the folders full permissions.

Nevermind I found it.

Ells (8/26/2009)

---

I would edit the package and put in a script task prior to calling the stoired proc. Put a MSG box in the script task. Run the package the...

Ells (8/26/2009)

---

Is there a default value for the parameter in the stored proc?

What is the default value for the variable in SSIS?

Can you see what the value of the variable...

OK I successfully added an expression but when I run the expression and check my code I get the following errors on Execute SQL Task:

"The result of the expression \"\"EXEC...