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,...

I agree with your findings - it's as if the insert happens and then rolls back, using up a number in the process.

I do not know whether that behaviour can...

Assume that you have a Boolean variable called Test. Here is how you would set it to True using a Script Task.

1) Create a Script Task.

2) Add 'User::Test' (no quotes)...

This should...

Here is how I would do it, I think.

1. Ensure that there is a string variable defined (eg SourceFile) which contains the filepath of the source data (eg C:\Ryan\Output_.xls)

2. Create...

Should not affect that - I assume you are talking about an IDENTITY primary key?

There must be something else happening ... can you post a bit more detail?