Cheers Dwain, thanks for this

dwain, first off, I've just finished the article you sent on. Its similar to what I'm planning to build alright but slightly different. The dynamic search stored procedure will be...

Hi Dwain

Insert Statement:

INSERT INTO [Criteria]

([TeamID]

,[WorkGroup]

...

The function at present simply takes in 5 parameters and based on 1 or more of these values, the case statement within the function will return the ID where the...

Thanks sestell, any chance you have any examples of this?

Originally this code was written as a function so if I can I'd like to keep the query using a function...

That's right Koen, the only mapping available in the metadata is F1, nothing that actually references the actual names of the headers that are in the file itself. I'm guessing...

I have it set to NO but it makes no difference

Thanks Hanshi, I'll try that the next time the cluster fails over onto the 2nd node

Terence - Yep I know that if I change the job step to run at the full file path for using dtexec or dtsrun it will probably work but unfortunately...

Hanshi, same version and same Path in environment variables

Unfortunately I can't do much testing until the next time the cluster fails over onto the offending node again

Another note on this, I tried recreating this in a virtual environment with an image of the instance and replicated the steps as per the MSDN blog, the package worked...

Gave up trying through SSRS and did it via the select query instead

Thought as much, thanks for the reply mate

Thanks for all the help on this Gail

We still have the 2000 instance of this db, is there anyway we can pinpoint the change at that level, identify and migrate the fix?