Erik Kutzler (8/27/2008)

---

Execute SQL Tasks don't like SQL statements that have parameters and also do things like create & drop tables.

Easiest fix is to create a stored procedure that executes...

you could also use "set datetime dmy" (in case the...

Hi Satish,

You can do this the same way you would do it in a query analyzer session

I don't know the name of your instances but let's call them 'farawaydb'...

Hi,

still need help on this one ?

Matte

That's what I meant,

the code should be put in your 'Execute SQL Task' where you access one DB as local and the remote as a linked server (see sp_addlinkedserver).

Matte

Hi,

I've had similar problems in the past, in my case it was due to the network drive not being available on runtime. I solved it by replacing it with...

Hi Satish,

you could perhaps try to achieve it using set-based statements, something like :

--------------------------------

--rows that do not satisfy COND1

--------------------------------

insert into dest_table_1 (colname1, colname2, ...)

...