Well the answer was easy. The problem was that I didnt think!

In the script component in the data flow, I wanted to get a value out of a row being...

Hi

I saw that someone mentioned the VariableDispenser class but could not...

Hi Dan, Yes that correct. I need to read in a value in row 10 for example and then use that 1 value later on when I get to the...

Jonathan Mallia (4/16/2010)

---

if you have any indexes, disable or drop them, and recreate afterwards.

Also, do the same from any triggers.

Furthermore, set the database recovery mode to bulk logged and reset...

2C worth,

In SSIS you get the graphical interface as well, which help a good bit if you have complex movement of data. My current SSIS packages all make use...

Well dawalker-1068762 thanks a mil, I didnt know that. When i do this again, I'll check it out!

GilaMonster (1/12/2010)

---

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most of the time), we...

Hi Hans

Ok, I understand, I was thinking that there must be some or other setting which SSIS was using and that it would really retreive the data.

As I mentioned...

Hi Hans

Had a quick look but it seems to be only a setting in SQL Server and not in SSIS it self or is there somewhere in SSIS where I...

Problem solved!

First of all, what I tried is to change all the

"DelayValidation">0 to "DelayValidation">-1, which didn't work, my package still just sat and did nothing.

Then I went to check...

Hi guys

Thanks the response! I'll try the suggestions tomorrow, at present I'm struggling with an SSIS import. Will keep you posted

Just to add; also solved my problem by adding unique non-clustered index on the lined table

I think that the standard keeps on being flat files, either delimited or fixed width.

Seeing that you want to send data to another company, I take it that could...

umailedit (7/13/2009)

---

Its called putting all our eggs in a collective basket resulting in a single point of failure. We designed the internet to avoid single points of failure, that...

I'm not sure from what sort of database you are getting the data from the mainframe, but I about Adabas, and in Adabas you first have to unpack the type...