I've attached the execution plans for both the function and the run-in-console modes.

The dress code issue is one near and dear to my heart. I've successfully lobbied to get dress codes changed to more casual ones at several places that I...

When I was learning SSIS, I found Marcin Policht's article series on SSIS, accessible from the article index at http://www.databasejournal.com/article.php/1503191 to be most helpful.

It would be awfully cludgy, but if you have file system access from your executing account, you could try putting some type of file watch process on your inbound data...

Is it permissable within your environment to use an upstream process to capture the dynamic file and copy or rename it to a known static name? That's how I've...

I've never tried it on data that would comprise multiple columns in an output table at once, but for simple package variables, you can use a derived column transformation to...

Are the input and output field collections similar enough overall to allow a previously-created template package or limited set of packages to be modified via Package Configuration settings that are...

Without knowing more about your data flow, I don't know exactly what advice to offer. Have you verified that in each case the db columns are wide enough to...

That is certainly the case where I work. ...

dekhle (11/19/2008)

---

Can we use one xml config file for multiple packages? If yes, how are we going to store the different connection strings in one file and how to idenetify...

The vast majority of my data sources are CSV files, and I always bring them into the data flow as strings, then validate them and convert them to their appropriate...

jonathan.strauss (11/20/2008)

---

Hi there

- From what I have gathered so far in SSIS, a package can't contain more than 1 data source. If correct, have one ETL package (on the ODS...

For the poorly formed date fields, you may have to use a Derived Column transformation to trap them, and then either null them out or insert a known "unknown" token...

If the tables that you will be importing are going to have a static layout, you can build multiple parallel data flows that convey from table to table without having...

Several of my previous positions have employed biometric security hardware, and I have always found it to be of questionable value, at least in its current incarnation, largely due to...