Looks like I left off a string conversion. Add the ToString() method to both of the .Value objects, as such:

dts.Variables("OldFile").Value

becomes

dts.Variables("OldFile").Value.ToString()

... and so forth.

hth,

Tim

Good deal, thanks for the follow-up.

I see. In that case, visit my blog post that I linked in the previous entry - if I understand correctly, that brief post should give you what you...

When using the script task (not a script component), you don't have to pull the file into the database to be able to work with it. Using a script,...

I agree with Sabya - if you're using the fully qualified name, you should get everything including from the drive/folder through the extension in your variable.

hth,

Tim

The short answer is no. As Phil wrote, you will in most cases be using a different connection during runtime, and any temporary object created under a different connection...

I assume that you're mapping the variable [User::uvFilename] to the filename in the For Each loop? If so, when you append the current date to the filename, the expression...

Good point, and I've found through my experience that it is indeed easier to meet people with whom I've already established an online rapport. More importantly, it makes it...

Excellent, glad it's working now. Let me know if I can help with anything else.

No, I pulled up the package and it looks like you've got it configured correctly. Is it possible that there are multiple worksheets in your Excel document? SSIS...

Are you using any external configurations, or are there any other expressions in your package? If not, it sounds like everything may be configured properly.

If you want to attach...

Single-click the Excel connection you're using, and press F4 to bring up the properties window, if it's not already open. Click the ellipsis button beside the Expressions item, and...

I'm not a language purist, but I prefer C#. I've used both C# and VB.NET, but having taken a lot of C and Java in college, along with my...

Just curious what kind of process would require loading a single random file from a given directory?

Also to be considered is if you can process the same file twice? ...

If you have more than just a few exclusion conditions, you might use a lookup transform instead of a conditional split. For your lookup query, use something similar to...