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

Have a look here and see how you get on.

Are you running on a 64-bit server? If so, have you tried running the package in 32-bit mode to see whether that fixes your problem?

Are you saying that you are getting an error before the script task even executes and that that is why your breakpoint is not being hit?

It would help if you...

I see. No, you need to use variable mappings to get the array members into a string variable.

But then you can directly execute the contents of the string variable in...

Is the requirement exactly the same for each server?

Is the schema exactly the same for each server?

If so, you can execute the same process over and over again, against the...

OK, I've just mocked this up and it works.

First, I have two package-scoped variables:

DropTablesSQL - object

strSQL - string

Next, a script task with DropTablesSQL in ReadWrite variables:

Public...

Going back to my suggested method, can you confirm that you had configured the variable mappings page for the FEL?