So all of the source files have the same number of columns and could be accommodated by string datatypes?

That is, you could read in all the data as col1, col2,...

Here's an example I got from MSDN which may help:

Dim arr As New ArrayList

arr.Add("D:\Tests\a.txt")

arr.Add("D:\Tests\b.txt")

Dts.Variables("User::Collection").Value = arr

Can you also confirm that your User::FileNames variable is of type 'Object'?

To perform updates use an OLEDB Command within your dataflow.

Can you confirm that if you fix up the header in the source file, everything runs OK?

If so, can you post some actual data - just the first couple of...

Bru Medishetty (1/9/2010)

---

Are you seeing that last line only is not being imported?

Check if the last line has any additional data which does not align well with the rest of...

Or you can reverse the string and parse from the right - useful if there is a possibility of multiple '=' or ';' in your input strings.

REVERSE(SUBSTRING(REVERSE([Column 0]),2,FINDSTRING(REVERSE([Column 0]),"=",1) -...

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.