You can't easily parse that. I'd bring all the rows in to a single Varchar field and then use T-SQL to parse it.

If you want to exclude rows depending on...

Wow, did Mr Rowan get his own command? 😎

Sounds to me like you are asking someone here to provide you with a working solution. That's not really how this forum works - people here will provide you with...

jyoti_bhatt (1/5/2010)

---

E.g.

Name Address Phone Age

aaa bbb ...

Can you provide an example - just 3 or 4 rows - showing what you mean exactly by "blank with no data"? Can a column be "blank with some data"?...

Much easier - I always choose CSV over Excel, given the option.

User::FileName

and it's case-sensitive.

Trick? 🙂

Why not use Windows Authentication - as desired - but have a File System task that runs first to copy the file to the local server? Then run your...

Dataflow with appropriate source and target connections.

It seems that you are not alone in having this problem. One solution might be first to copy the text file to a local drive on the server & then...

OK, I just read this a bit more carefully.

Can you confirm that the number of columns in the datasource and their names and their data types are always the same...

As Sabya suggested, please read up on the SCD component and then post back with any additional questions.

You chose ... wisely.

Could the column names in the external text file be changing?

a.hadss (12/30/2009)

---

see this is what i hav...

in the database:

table one: Customer(ID, Name, Age, Location_ID)

table 2: Location(ID, LOC_NAME)

in a datawarehouse:

table 1: Cust(ID, Name, Age, Location_Name)

now i want to refresh the dataware...