Sharon,

You're rigt, if I had my 'druthers' I wouldn't go about it this way either. Unfortunately, I'm severely limited by my "development rights" and tools.

The end...

Thank you soooo much...this is without a doubt the most detailed response I've received.

You are correct it doest sound like good news, but it helps to know what...

Did you get an answer to this? I'm having a similar issue. I need to call an SSIS package from Microsoft Access 2007.

My apologies, you are correct. My response was too brief to be informative (as informative as yours). It was purely meant to provide an alternative for the Instr...

Instr is the PL/SQL equivalent of Substring. In SSIS try the Substring function.

Hope that helps.

Good question and at least it lets me know that I'm heading in the right direction with my troubleshooting. The simple package "as you describe" is 5 dataflows. ...

Would your suggestion be the same when the datsource is an ACCESS database that is the source for follow-on packages?

Thanks,

Sabrina

Hi,

Have you tried adding a script task to display the variable value to make sure that you are in fact reading the variable into the package?

Sabrina

Hi Phil,

Thanks for responding. It is curious indeed. For testing I did a select * from . Its a table that has 2 columns and...

If I understand your post correctly then it's probably because it's set to validate.

In your tak properties, check to see if the DelayValidation property is set to True....

I still consider myself a newby too and have been learning SSIS from our online peers and books. I found the WROX series for SSIS 2005 to be very...

This is an interesting way to address it. It doesn't do exactly what I need it to do, but since I hadn't thought of a dropping in multiple data...

Rob and Journeyman,

Thank you both for your post. You both had a piece of the solution. Turns out that with the msgbox, I could verify that the...

Any resolution to this. I'm having the same problem. I have the script task in the control flow, made sure by copy/pasting the variable names were accurate, and...

Can you clarify your request?

Thanks,

Sabrina