So if the base value is 601.1.01 - the lookup will be for region 6601, port 1 poll 01?

You also need to provide samples of the [base1], [base2] and [base3] values.  Those are the values that are passed into the function - to return the base equipment address.

The...

If you could put that data into temp tables - with create statement and insert statements - it would help.  We could then take that sample data and use it...

@JeffModen - this is why I asked for sample data being passed to the function.  We can make the assumption that the values being passed in are numeric - but...

Okay - assuming they are all SSIS variables, then make sure you use the proper case.  Also, I would rewrite the code...

// Get the DTS variables into...

Are these SSIS variables or package variables or project parameters - and did you add them as read-only variables in the script task properties?

I understand what you are trying to...

OperatorBadgeID are only used by one Operator, not shared. Some do work in more than one area of the plant, so, yes, there can be duplicate entries, one for...

I know it doesn't contribute to the conversation at hand but it's just fascinating to me that this type of thing is still an issue since the release...

SSIS packages are not interactive processes - they are background processes and do not provide for user interaction.  There are no options to prompt a user to continue.

As for truncating...

Why would you check for the existence of the file - when the foreach loop has already found the file?  If the tasks inside the foreach loop container are executed...

The code you supplied does not show the usage of the function - I have to assume it is being called in the stored procedure.  The stored procedure has 3...

Yeah - didn't see that...

Can you provide the code that calls this function?  Is it called directly from your application code - or is it within a stored procedure or other query?

And do you...

I wonder - what happens if you run DBCC UPDATEUSAGE on that cloned database?

If I recall - there are different methods that can be used when you clone a database.  One of the purposes is to retain the statistics - so you can...