I found the problem - the Constraint needed just an expression and it needed double equal signs: @[User::TrainingFilePresent]==1 and @[User::TrainingFilePresent]==0

Thanks!

The variable for the path is ReadOnly, the variable for the filename is readOnly, the variable for the FilePresent is Read/Write

I've got my Foreach Loop Container in PROD and it is doing what it is supposed to do so this is really just a learning experience.

I put this in TEST:...

What I would like is the flexibility of things like displaying a message like "File not found - continue Yes/No?" or truncating a SQL Server table based on the results...

If I needed still, with using the Foreach Loop container, to check for the existence of the file do I place an Expression task before the step to set the...

I believe the method of utilizing the Foreach Loop Container is the most straightforward solution, but I'm sure I need to learn more about the other methods, as situations requiring...

So I could in fact use the Expression Tasks alone without the Script Task, and those Expression Tasks could determine if the file existed in the folder?

If I wanted to...

So do I still need the Script Task with the C# Code?

All is working now... Cross apply is a great tool

I'm still getting the "Invalid length parameter passed to the LEFT or SUBSTRING function." error.

LEFT(SUBSTRING([AGENT],CHARINDEX(')', [AGENT])+1, LEN([AGENT])-CHARINDEX(')', [AGENT])),CHARINDEX('-',[AGENT])-CHARINDEX(')',[AGENT])-2)             -works!

I get a "Invalid length parameter passed to the LEFT or SUBSTRING function." error plus what if in the number there were a letter like '-16LK5'?

This works most of the time but if I have data like '(t) Jamie Guy -692' it does not:

LEFT(SUBSTRING([AGENT],CHARINDEX(')', [AGENT])+1, LEN([AGENT])-CHARINDEX(')', [AGENT])),LEN([AGENT])-10)

• This reply was modified 4 years, 2 months ago by DaveBriCam.

What about a different datatype in SQL... Blob or Html? Would the text shown go into that?

• This reply was modified 4 years, 3 months ago by DaveBriCam.

I was able to get the package to run but the csv is proving to be useless since it inspite of being 1020 chars in the SQL table it cuts...