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

Use a Conditional Split and send the unwanted row(s) to an output which goes nowhere ...

A possible alternative is to delete and recreate the sheet you are working with, using Execute SQL tasks against an Excel Connection Manager connection ...

DROP TABLE 'sheetname'

followed by

CREATE TABLE 'sheetname'...

Aggregation can remove dups too. But it all works faster using the database engine, as already noted.