I see the former as reinventing the wheel rather than the latter, but I can see reasonable people on either side.

Incidentally, a lot of stuff in SSIS can...

To me, the whole ssis/variable/data transformation route is hugely over-complicated it. SSIS tasks shouldn't be used to replicate basic SQL functions.

Just use an Execute SQL task and refer to...

For sure, and I usually do that. This is in a situation where the preference (for whatever reason) is toward dynamic sql statement. And usually the reason...

Could be executing an Update or a Delete, as required.

In this case I found the solution! I didn't actually realize just how easy it was to convert...

Edit - FINALLY figured it out. Despite the fact that the BAT file is in the certain local folder, and that final BAT file opens a PSFTP in that...

From what I am learning in SSIS (am pretty new), I think I agree strongly about script tasks being preferable in some things - most notably, so far, file system...

I was unable to ascertain to a certainty when the package lets the files go. Either way, the fact that they were being locked was indisputable I guess. ...

OK thanks.

1) How would I Pause/break the SSIS package at the specific time to see what has the files open? In the middle of the Foreach file enumerator?...

Thanks, good tip. I'll see if I can get "IT" to help me out in that regard. :w00t:

The files are being created at a single point in time, daily about 4:00 AM. I'm running my process way after that. I don't have the files open,...

Paul, The site I had found the PDF download offered from was on the first page of a simple google search "Kimball Data Warehouse Toolkit". Being offered so brazenly,...

Paul,

Guess I hadn't verified it specifically, per se, as the IT e-books website brazenly offers it for free as PDF download and claims it is authorized to do so for...

I was able to solve this because eventually I realized that I needed to drag a flat file destination, not a flat file source. Seems obvious, but the article...

Ahh - OK, thank you.

Delay Validation and BypassPrepare sound like the same concept, implemented on different objects basically -