For anyone else that might end up having the same issue, here is a fix. Having said that, we are using fairly old versions of SQL/SSIS (2005) and Windows Server...

Hi Lars

Thanks for taking the time to reply. Yes I did something similar. I added a variable to the StandardErrorVariable property on the Execute Process Task in order to ascertain...

I found a work around.

I set the TextDelimiter= setting in the Schema.ini file to a character that is highly unlikely to ever be used.

I set it to TextDelimiter=` and...

Thanks Cold Coffee, your Sub Query method was the way I was leaning towards, just couldnt work out the syntax.

Cheers.

Found it. I used the following.

Set @sql = (SELECT m.definition FROM sys.sql_modules m, sys.views v WHERE m.object_id = v.object_id AND v.name = 'view_name')

Tks

There is no "GO" in my code, so must be something else. Thanks for the suggestion though.

Cheers

Doug

Yeah, figured as much and done so already, just thought I'd put it out there to see if there was a solution.

Tks.

Long story but it is feasibly that I am encountering a deadlock on the schema ... hmmm not sure but I'm no SQL expert.

I'll try to explain.

I have a stored...

Thanks Ron

Firstly, I wouldnt consider myself an SQL expert, but yes, I am familiar with the TRY...CATCH construct.

I may be missing something, but l dont think it will help me...

Thanks Todd

Sounds like a neat solution. I'll certainly look into.

Cheers

Doug

I managed to find a solution.

I'm using xp_cmdshell to execute an Echo statement to create and subsequently append to the error file. I doubt this is ideal and I dont...

Dont worry guys, figured it out. Always happens just after you've posted a question.

1. I created a variable called varMaxFilesFTP.

2. I set InitExpression: @varMaxFilesFTP=1, EvalExpression: @varMaxFileFTP<30, AssignExpression: @varMaxFileFTP = @varMaxFileFTP...

Hi Guys

If i could bother for one more piece of advice to close off this task.

The above works really well, but obviously only download a single file. i.e. the file...

Thanks Guys, I've sorted it out.

I was coding this one step at a time so started with the variable and script, however, it does update the variable and the...

Thanks Raunak, I'll look into it.

Cheers.