It might be just anything . Currently in QA we have files like ME_01_2011.07.29AMTRAK.xls

LTL_08-16-11_IVS_Hydro.xls

BurkeOil080111-080711.xls etc

The path of the source files is P:\Import\FolderName_QA\

This path might/will change later...

I get the below error if I use the expression that you suggested.

The start index 0 is not valid for function "SUBSTRING". The start index value must be an integer...

How to use wildcard pattern in Foreach loop container ? I am stuck here. 🙁

Should I use Enumerator configuration : Name and extension only ?

Thanks

Thanks All for the help.

SSC, you code works but it pulls the Food & Liqor.

I want To pull locations only if count of locations = 2 and Ids are...

Thanks everyone. Merge worked for me

Thanks.

I tried to use SSIS . When I tried defining the source connection manager for this server, I couldnot get the drop down list of the databases available in that...

Thanks everyone !

Thanks Union worked !

This doesnot return any data!

No. I didnot get any data. I need to retrieve data between 11pm and 6am.

CREATE TABLE [dbo].[ABCD](

[InternalID] [int] IDENTITY(1,1) NOT NULL,

[RecordInternalID] [int] NULL,

[ProcessorID] [int] NULL,

[Terminal] [varchar](50) NULL,

[TxnTypeID] [int] NULL,

[ResponseCodeID] [int] NULL,

[RejectCodeID] [int] NULL,

[BankID] [int] NULL,

[NetworkID] [int] NULL,

[TerminalSequenceNumber] [varchar](50) NULL,

[SettlementDate] [datetime] NULL,

[SettlementTime] [datetime] NULL,

[ActivityDate] [datetime]...

Can anybody help me ?

User::FileId is a variable that holds the FileID of the file loaded.