Hi everybody,

Two days I spent and could not find a simple problem in the InsertCommand for the data source. So finally I created an SP in SQL Server (that was advised by my friend yesterday) and it was a very simple problem

insert into Table (LTRIM(RTRIM(@Par) ... ()

The command itself is much more complex and it starts with BEGIN TRAN and it has two insert statements.

So I fixed it now using configuring data source option, but the Finish button is not becoming active and Query builder also returns an error that it can not parse it.

I can do it manually, but may be I should really use SP in this case (the one I just created)?

What would you suggest?

Thanks in advance.