The steps to pass values from a script task back to SSIS are:

1. Define the SSIS variables (doh!!).

2. List them in the "ReadWriteVariables" entry for the script task. You...

Loner, I think you're confusing the Script Task with the ActiveX Script Task. I've been using an on-line edition of the book at the subscription-based site http://www.books24x7.com. The...

My, my, my. E.F. Codd is rolling in his grave now -- laughing or not, I wouldn't know.

I've seen small examples of this sort of thing before...

I used this book to get going with SSIS. I would rate it a bit lower than Steve did, maybe 3.5-4.0, but then I'm not buds with the authors...

Excellent question in that to understand the result, you have to step through the entire process.

--The statements compile.

--Each "select" is executed.

--Then the two result sets are...

I don't know if FileWatcher itself has a memory leak bug, but apparently SSIS does when running infinite loops. See the comments in Jamie Thomson's blog: http://blogs.conchango.com/jamiethomson/archive/2006/10/18/SSIS_3A00_-Random-information-for-beginners.aspx

Since you're interested in the values down to the millisecond level, you'll want to remember that the internal (binary) precission is to 3.33 milliseconds and is rounded to increments of...

I wonder about why one would want to append a constant ".html" to a particular column and store the result in the database. For any larger number of rows,...

It's not so much code portability as developer portability. I prefer being able to use...

It's been suggested that "COALESCE" is preferable to ISNULL.

It allows for a list of arguments, the first of which evaluates to not null being returned.

Coalesce is ANSI standard; ISNULL...

Thanks, rbarry.

What was missing was on my end -- should have looked more closely:blush:. Now it's obvious that any of the sought-after months would make one of the differences...

rbarryyoung, I don't quite follow your code, there. Somethng missing?

Anyway, it did inspire what may be the most obscure solution yet. We define an integer to hold what is...

You can set properties for the task that connects to each db -- FailParentOnFailure and FailPackageOnFailure are "False" and MaximumErrorCount = 9999. With these settings, even if the task...

I started to agree with you, Mike Dougherty, about a separate table of date ranges, applauding your generalization of the query to allow configurable ranges and not just calendar months,...

Just curious, but is there any other processing done to the records besides splitting the no-lastname ones to a flat file? If not, my inclination would be to have...