If anybody needs to know how accomplish a simular task the solution is create a string variable. Then in the for each loop container set that variable in the variable...

Fantastic, many thanks

opc.three (4/20/2012)

---

AIRWALKER-375999 (4/20/2012)

---

Thanks for your response. I have already tried that appraoch but because the files are created at the same time the 2nd watcher does not recognise the...

Thanks for your response. I have already tried that appraoch but because the files are created at the same time the 2nd watcher does not recognise the 2nd file...

opc.three (4/3/2012)

---

Here is a WQL Query Tool for you to develop your queries:

WQL Query Runner[/url]

In using a drive letter, are you sure the drive letter will exist for the service...

Cheers, I think this is the way to go, could you help me with the wql query. The files sit on another server which is a mapped drive(k:\) on...

opc.three (4/3/2012)

---

Craig made some good points about why not to have a package running all the time. If you are fine with it and want to proceed, or are bring...

Evil Kraig F (4/3/2012)

---

AIRWALKER-375999 (4/3/2012)

---

opc.three (4/2/2012)

---

You may not need to rig something like that up. What event are you waiting to see happen before your Script Tasks do work? Are...

opc.three (4/2/2012)

---

You may not need to rig something like that up. What event are you waiting to see happen before your Script Tasks do work? Are you by chance polling...

Hello, after doing some research I think a 'For Loop' container would suit my requirement. For example if I set the InitExpression to be GetDate + 10 seconds and then...

I've found out that this is not actually possible, but I can acheive the same functionality by using a script task to set a variable and then using Precedence Constraint...

Ahh yes, I see.

Many many many thanks!!! BTW, do you know of a website or book that covers this kind of tsql

cheers!

Just 1 more question (and thanks so much for your help)

If my table had another field (JOIN_TYPE):

USER_ID | ACCOUNT_ID | TEL | JOIN_DATE | JOIN_TYPE |

0001 | c0001 | x...

Thanks very much for this. One more quick question, when performing a task such as this, would it be always best to use this type of stored procedure or could...

Hi Elliott thanks for your response,

the excel file our ssis packages uses goes on a short journey before it end up on the database server,

it is uploaded to an ftp...