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.

Ah yes - that copy line was causing me pain because my file system does not have the path you were using, so I muted it 🙂

Change your Evaluation: Expression...

Try this:

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

Public Sub Main()

Dim FileSource As String, FileDestination As String

Dim file As FileIO.FileSystem

...

Interesting. Can you give me an example of what your source file variable contains?