As SSIS is largely meta-data driven and you are not able to provide this meta-data - because it is not known in advance - you will find it difficult (now...

Yes it does. Give it a try and see how you get on.

In your example, there is no tab after char1, the 'code', yet the rest of the data has tabs delimiting the fields. So it's really not clear - it looks...

I don't see why that precludes the use of a query for the source, but I guess you have your...

Change your source from a table or view to a query and perform a CAST there ...

Welsh Corgi (1/11/2010)

---

Sir,

I can't confirm that because the BO is out of town.

I have always been able to set standards for naming conventions and file formats but I...

Why not just set a breakpoint or two and then run the package? You'll get into a full, interactive debugging session, much richer than writing out the odd result to...

Use a combination of LEFT, CHARINDEX and SUBSTRING to split the field up.

If you read the contents of your single record into a variable (or variables), you could then create derived columns using those variables in your main dataflow.

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