LineNo is a SQL reserved word, so I would suggest you find another name. If you however have no other choice, wrap it in square brackets which will do the...

• This reply was modified 5 years, 2 months ago by  Gerard Wolfaardt.
• This reply was modified 5 years, 2 months ago by  Gerard Wolfaardt.
• This reply was modified 5 years, 2 months ago by  Gerard Wolfaardt.

Here we go...

I've managed to figure out that if I have an SQL task that executes before a Data Flow task in the Sequence container it hangs. I can have...

I'm getting exactly the same problem with the Transaction Option property of a Sequence Container set to required. The package gets stuck on as soon as the Data Flow Task...