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?

jim (7/16/2009)

---

Hi Phil, the data source is a table from SQL server rather than from a file system. So, can I still use your script to do it? Thanks a...

ryan213 (7/16/2009)

---

Hey Phil,

Do I need to change anything in that script? I'm pretty sure I followed everything. I created a string variable called SourceFile that contains the location/filename...

Huh? Are you talking about a row-by-row comparison, or something else? What do you mean by binary - are you referring to a checksum?

More detail needed about why you are...

You should not need a script.

Configure a flat file connection, setting the format to 'fixed width' and then set all your start positions and lengths ...

No problem. Just a script task is needed to take the variable containing the file name and do the file copy for you. This would be on the Control Flow,...

Whoa, what is that!? 😀

I'm assuming that 12345 is just dummy data and not some obscure representation of a date (number of days since a blue moon,...