What is the warning message?

Nice question, thanks.

Jeff Moden (12/4/2011)

If expert knowledge of SSIS were gasoline, I wouldn't have enough to drive a...

Hmmm, at first sight that error has not much to do with checkpoints.

How do you populate the CustomerID variable?

Luckily, this is very easy in SSIS (maybe easier than in TSQL? :-P) using a very will hidden property:

http://sqlblog.com/blogs/jamie_thomson/archive/2010/03/31/filenamecolumnname-property-flat-file-source-adapter-ssis-nugget.aspx

Is it possible to give sample input and desired output?

Your explanation is not entirely clear.

What is the error that you get?

Wise suggestion: do not use checkpoints. They only bring pain and misery 🙂

Design your package in a way that you can restart it without...

The JurisID column, is that one already calculated or do you do it at the same time?

Why don't you take the current value of the JurisID column, instead of the...

Nice question. Always good to freshen up XML a bit, as I almost never use it.

Nice question, thanks!

Great question, thanks!

SELECT F1 AS MyColumn FROM [Sheet1$]

SSIS could be giving troubles because of the length of the text. (there is a 4000 character limit, but I thought this was only in expressions)

I would do this in...

It's not just you 😉

Try adding SET NOCOUNT ON at the beginning, as you have multiple SELECT statements in your query, albeit that only one returns data.

If you execute this in SSMS, what do...