My suggestion is to add an error output to the components that are giving you errors. Send those rows to a separate table with the error information or to...

We had to submit our final masters’ paper to some service that tried to catch plagiarism.

In that same online program, a fellow student posted lifted a long web article intact...

Can you view the file using some kind of binary viewer? It sounds like there is a null character (ascii 0) after the numbers.

When do you get this error? Running BIDS or when the package is deployed?

Where are these system generated exceptions occuring? In the script task/script component?

What happens if you run the following:

"C:\Program Files\WinRAR\rar.exe" -a C:\list.txt C:\MyCompressedfile.rar

Do you need "rar" in the arguments?

You could use the ExecuteSQL task with a connection to the remote server. You load the value into a variable. If it is the right value then continue with...

I'm trying to make this work with just an expression and it is complicated. I would go back to using a script component to strip out the date portion...

I think I see where you are going with this. Very clever.

In the Precedence constraint you need an expression that parses the last 8 character into a date string...

You could use a ForEach container to iterate through all of the files with a pattern: Package*.txt

In the container put a Script task. Test the file name pattern for...

I'm in favor of porting your code. I think that the main code you will need to change is how you instantiate the workbook. But the rest of...

No alias. I'm convinced that almost all people have been burned or seen friends burned by management, not for the good of the company (which would make some sense)...

The only place I can think of where a PK would not be workable would be in the very rare occasion where you want to use a nullable column as...

It fascinates me that managers can drive out their staff and actually get rewarded, when the most valuable asset managers work with is their people. A manager goes...