I'm with Alvin (as usual) - Script Component with multiple outputs to your various different tables.

Great - thanks for posting back.

Specify " as your text qualifier in your flat file destination connection manager.

Just because you update a variable when your package executes does not mean that the value of the variable will be persisted in the Variables window afterwards.

Try putting a script...

Does View/Error List give you anything useful?

Alvin Ramard (10/5/2010)

---

Phil, I'm not sure what you're asking? ...appropriately...

sqlusers (10/5/2010)

---

sqlusers (10/5/2010)

---

Leo Suresh (10/5/2010)

---

I guess you are using table variable inside your SQL query. If that is the case, then OLEDB source task will not generate the columns.

Use a...

Alvin Ramard (10/5/2010)

---

Steve Hindle-535638 (10/5/2010)

---

One more question on this...

As I split the records up from the original file, the detail records need to have some information from their header records...

sqlusers (10/5/2010)

---

Exactly i want to get all the data's. That'y i use loop through.

Here in table...

pwalter83 (10/5/2010)

---

Hi,

I changed the Run64BitRuntime to false, now it shows another error: violation of primary key constraint. The error is below:

[OLE DB Destination [9]] Error: SSIS Error Code DTS_E_OLEDBERROR. ...

sqlusers (10/5/2010)

---

Actually, i need to get the data's according to From and To Date from a table. So for that...

Try running the package in 32-bit mode and see whether that fixes things for you.

Is your server 64-bit?

Why does your data source contain a WHILE loop?

I agree up to the point of importing as a single column and firing into a Script Component.

From there, I would do things differently from what is suggested: a Script...