I am afraid I have no idea what could be happening, it all sounds very straightforward.

Does it always process exactly the same number of records? If yes, try putting an...

Thank you Allen - I was looking particularly healthy and radiant the day that one was taken :w00t:

When you modify a package in BIDS, you are probably updating a version...

While it may well be your company's policy to do this, it is not mandatory.

It is perfectly possible to create a SQL Agent job to run a package which exists...

phumlo1 (7/22/2009)

---

Hi all,

I am using an OLE DB Source in an SSIS package I inject sql script below to retrieve data from datasource. The source has 700 000 records but...

In an Execute SQL task, if you want to build a dynamic piece of SQL that includes variables, use the 'Expressions' area to override the SQLStatementSource property & this should...

There is perhaps a more elegant way of achieving what you want - check out "Creating Package Configurations" in BOL.

You could have a variable called (say) LoadDate which is assigned...

What does the ActiveX task do? Does it fail at a certain line, or does the whole task fail? Does it fail only when executed by the SQL Agent service?

Strange. You could try removing the variable from the Read/Write section and instead use the VariableDispenser method to retrieve/set the variable.

Running the restore from Server A would work fine, I believe. Server B would still be the one doing all the work: Server B is just issuing the control commands.

Why does the Server A task need to wait for the Server B task - is there some dependence there that you have not mentioned? What happens if the Server...

1) Create a Double variable to hold the result of executing the max sal query

2) Create a String variable to hold your variable SQL.

3) Run an Execute SQL task to...

So N is a Name record, A an Address record, etc?

Please explain what you mean by this and give...

It's always a pleasure helping someone who's enthusiastic and eager to learn.

No rep points here - just hoping that good SQL karma will come back to me when I get...

Is that a bowel problem? :hehe:

What do you mean?

Also check that the BudgetFilePath variable has been set so that it points to a valid file so that SSIS's meta-data validation does not fail.