Thanks for the suggestion. Unfortunately, I don't have a DB2 ODBC driver on that machine and it's not likely I'll be able to get one.

Do you have to do something to turn on keyboard shortcuts? I have done this but when I press Ctrl+F1 nothing happens.

Thanks,

Brian.

I would like to add that there were other queries that had hung also that did not use the ODBC driver. They were connecting to a remote SQL Server.

Also, there...

I'm not sure about this since in your example it...

Actually, it's 30 columns. I didn't put them all there.

I found a slightly better solution. The first column is DB server but it can be derived from File Server...

Thanks for the feedback. I thought I was missing something simple. What I did was to increase the length of the first input column, then parsed it in a derived...

Thanks for the feedback. I didn't like the extra step of copying the file first but it does give some auditibility and is safer. In a few months, I may...

It's an inventory system and my understanding is that they are not storing anything but current stock level. The output stream is a log of the changes and was added...

I'm reading a CSV output file from a DB2 database. That database never closes the file until the end of the week and that's just before it deletes it. It's...

I did not resolve the issue, but eventually gathered enough evidence to show that it was the SAN and not the database. Our data center is moving and getting all...

Koen (da-zero) (1/13/2011)

---

You can force the execution result of the data flow to succeed, so your loop would always continue.

However, this raises another problem: how to detect failure? If you...

What did you have in mind? I could use this to set the global variable instead of a script task. That...

Our SAN is a Dell Equilogic. We don't have a SAN administrator, but the SA that takes care of it says that it's an old SAN and nothing is configurable....

I've read through the blog and it's useful. Most of the counters I have already checked and the bottleneck is clearly I/O. We may have a Windows problem because the...

Thanks for the info. I will check out that blog.

There are a lot of writes going on in this database. A lot of this is due to poor application design....