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...

@skcadavre:

Your solution will work on SQL Server, but not on Access. The getdate() function doesn't exist there.

As the OP proposed, the function DATE() should be used. However, I'm not familiar...

In the For Each loop, you can set the property FileSpec to a filetype, so that the loop only takes the file of that specific filetype. For example, if you...