I've just realised that to solve this, all I have to do is use SNAPSHOT ISOLATION at the subscriber. The subscriber does not need to change data, so this would...

Try creating your variables at the package level. You may need to delete your variables and recreate them with the mouse focus on the background of your package.

What property of...

You could put the name of the file into a Package Variable and then reference the package variable to set the Excel Source using an Expression in the connection manager.

You could use the File Watcher Task

See http://www.sqlis.com/23.aspx

Thanks Michael, but I still can't get it to work. This is exactly what I did:

Deleted my existing Bulk Insert Task

Deleted the associated Connection Manager for the flat file

Created a...

I'm not sure I'm following you. I am setting the path and file name. Could you expand a bit more? Thanks.

Thanks crever.

I guess one way that might be possible would be to open the package file in a text editor and hack the XML. It feels very dirty doing this...

Oh man that REALLY sucks. What if I have 90 columns and my users require the columns in a different order? I have to recreate the whole thing? This can...

I just did Imports System.IO

Thanks for your help crever (and great videos on your site BTW!).

I've got it working well now, although I'm sure it could be more elegant. Here's my "finished" code:

...

Thanks guys, I'm making some progress. Here's my code so far:

Public Sub Main()

Dim folder As String

...

Thanks for that I will test it out. It is certainly behaviour that I didn't expect. UDFs open up a whole world of possibilities when used with CHECK constraints.

Keymoo.

There is no data in the table. When I insert the first row, the constraint gets violated. Not sure why this is happening. The function works when tested in isolation,...