1. Oh no, I mentioned that :-).

2. I was still surprised that in such a small table the batches took over 5 minutes to complete.

3. the affect...

Aha, I didn't consider the mixed letters/numbers variations to test with.

Great. Thanks GilaMonster.

Thanks for the replies. I appreciate the advice regarding tuning the size of batches. Thanks.

MM, yes, you solved my issue, but just wondering ... do you know if the web service URL gets used for anything other than for connecting Report Builder to Report...

Mister Magoo, Thanks. I've installed it and it looks like I'll be able to create a report now.

thank you so much staying with me. Package is deployed!

I found this site http://stackoverflow.com/questions/25670293/ and modified as follows.

public void Main()

{

...

with just that one line inside public void Main(), I get squiigly red line under the whole of Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure; and error.

public void...

Is that two Logical And precedence constraints per sequence container, one with @a==@b connecting to next sequence container and a second @a!=@b followed by a script task ???

Also, not familiar...

I've mistakenly created a column as smalldatetime instead of smallint and have imported data into that table. The values in that column are all 1900-01-01 00:00:00.000 or 1900-01-04 00:00:00...

One of the variables is populated by a powershell script and therein lay the bug. My eyes finally attuned to the fact that the script was outputting a line...

Thanks Anshul, that right. I had to change variables scope to package level and error gone.

same as KoldKoffee (different computers :-))

since it's just a warning though, my package doesn't fail, though the consequences are pretty serious. Do you know how to fail a package on this partial row at...

Eririkur, this problem is gone at this time. I don't really know why. I reimported the files from ftp server, re-unzipped, and rebuilt from scratch the DTF handling of that...