Alvin,

If the package is just reading the a single file then definately the remaining files must be in a folder structure.

Check the Files text area..(have provided any delimiter or any specific extension)

Chek the status of Traverse Sub Folders checkbox

1. Create a ODBC connection in Control Panel.

2. Create a ODBC connection from connection manager is SSIS and map it to the custom connection created..

3. Implement a Script Task to...

Though by default there are no providers for Custom sources. You may implement the following:

1. Create a ODBC connection in Control Panel.

2. Create a ODBC connection from connection manager is...

Can we use xp_cmdshell??

DTEXEC and DTUTIL using the above call to SP

Thanks Andy,

learned really interesting fact today. kudos.

You have two options:

1. Implement an EST(Execute SQL Task)

2. Implement a Script Task with embedded .NET code

John Mitchell-245523 (8/20/2010)

---

Or, if the duplicates are definitely all within the text file (and not duplicates of data that's already in the destination table) then you don't need a lookup...

Andrew,

This is what I understand,

You have a file name such as MM\DD\YYYY_TIMESTAMP

In such case inside a FOREACH container you will have to implement a Script Task

A collection will store all...

Type 6 SCD transformation are very very specific.

Seldom the need arises to maintain a history table.

Puja...you know my comment was on a lighter note...we allare here to help each other....

I...

:-D:-D

You are scaring the girl!!!

I'm loving it...:-D:-D:-D

the forums in themselves are a haven for learning...provided one understands how to exploit them in your favour...

Happy learning

SBS and BOL

Why don't you transmit the edited file to FTP location?