Sounds like you need an asynchronous script component.

Well done. I have some ideas about how I would do it and will post...

SQL_Kills (12/16/2013)

---

1. I need to create a ssis package

2. I want it to query the orders table for each orderid then for each result set it returns for each orderid...

For each OrderNo I want to create a Text File into my C: Drive Folder, so the file name will look something like this "C:\A1000.txt" with each text file having...

Is there a chance that anyone (or even you) has one of the files open in Excel?

arooj300 (12/11/2013)

---

Thanks for the reply...

I want to clear my question , I think this will be easy to understand.

we have a production DB. we have millions of data which client...

+1 agreed this is sensible...

You're puzzling me a bit with all this talk of aliases.

Why not just use standard connection managers and configurations / environments to control what points to what?

Why does the absence of a PK have any...

abhas (12/10/2013)

---

Hi All,

I am siply loading and updating data from one table to another.But data is huge and number of column are also high. So i want to drop index...

No problem, happy to help - thanks for posting back.

I agree with John's diagnosis.

If you have multiple paths to a component and you want that component to fire when only one of those paths has successfully completed, you...

chholm (12/9/2013)

---

That's because I've only told you part of the story. This is part of a converting project. I'm moving all of the data from one database to another, but...

Confusing - yes it is! 🙂

OK, I won't spend any more time on the T-SQL side. But I haven't quite finished.

Your FieldB in TableA appears to be an FK to...

chholm (12/9/2013)

---

Hi Phil.

Thanks for instructing on how to make a good post. My apologies for using your time to making my post better. I've corrected and validated your code as...