Good old Excel. First place to start might be with IMEX=1 in your connection string. See here for more info.

Bravo!

RonKyle (1/12/2010)

---

I would appreciate more details. I have tried to use a variable both in a sql statement in the sqlcommand property and even created an entire sql statement...

You cannot. There is no data pipeline at the control flow level, so a conditional split has no context in which to run.

What are you trying to do?

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'?