The problem you described is an old caveat that exist (or did exist) in most programming languages.

Usually this is with the iif or iff syntax.

Most programming languages either deprecated the...

If you use a "logical" surrogate key in the fact table, for example 20100601, you can still have the time table AND fast searching and simple SQL queries against the...

Nice question.

What is the error that you get?

And why do you create a variable Filename that you don't use?

The following solution should work:

map the SSIS variable FileName in the For Each...

Sorry, I forgot.

In 2008, the For Each loop returns the directory + the filename, in 2005 only the filename is returned.

So, you need to construct an expression that looks like:

"\""...

I think it is better to use the For Each File container.

Point this container to the right directory and set up which files he must loop (.xls or .csv or...

At my current project, when I'm stuck with a problem for more than 15 minutes, I call an (older) colleague with much more experience than me. Mostly, when I'm halfway...

Allright Hugo, thanks for the explanation!

I do not fully understand.

The batch begins with:

SET IMPLICIT_TRANSACTIONS OFF

According to BOL, this means the following:

... SET IMPLICIT_TRANSACTIONS OFF statement, which returns the connection to autocommit mode. In autocommit mode,...

Nice (lengthy) article with great examples!

Not 100% sure what you need, but maybe you could use the following query in the configuration of the lookup component:

SELECT

Patient_ID,

MAX(Date_Column) AS Date_Column

FROM My_Lookup_Table

GROUP BY Patient_ID

This code will make sure...

Using select * could cause SSIS to crash if a column is added to the table (or removed). That's why you want to refresh the metadata, to stop SSIS from...

I don't know how things work in Informix, but in SQL Server you have system tables that contain all the table names.

You could write a script that iterates over this...

To be complete:

this is the second solution Phil spoke of:

SELECT ID, SiteName, DRCNum, TypeID, Point, [Time], CardNumber, FormatName

FROM TransactionLog

WHERE DateAdd('d',DateDiff('d',0,[TIME]),0) = Format(DateAdd('d', - 1, DATE ()), 'dd/mm/yyyy')

The combination of the...

I would do the following:

1. To get the 10k customer details.

Set up a OLE DB Source which will read your SQL Server table with 10k customers. In the dataflow, add...