not sure if you can bcp from proc. As far as I know, can only bcp from table, view and query.

what you can do is grab the result set returned from...

have you tried this sum(value1) + sum(value3) ?

your query has no control over how null value should be defined.

also if you do :

select sum(value1+value2) -- you get unexpected result.

one way is to use xp_cmdshell to call a batch file where the batch file contains the exec proc statement. In the function you can call the extended proc.

eg.

create function...

exec...

GilaMonst,

I'm not saying that you're wrong. What you got there is correct.

It depends on how you want to treat the null value.

ie. if it is null do you want to...

depends on how you call proc inside a function, there's  always a work around.

Don't just accept what it is in bol.

you're doing backup log from A and restore log to B.

if you want to create a new column do it in A, log shipping will automatically carry a new column...

replication is good a choice, you can control how/when you want to do the move.

another way is, what about using timestamp datatype on source and varbinary(8) on destination. This is how...

phil,

The orginal question "I can save a DTSpackage as DSTpack.BAS. But, how can I load this file again in my DTS-editor? I can do this with files with .DTS...

I thinks you still can....though I never tested.

if you can call clr in a stored proc you  can call it a function.

you have to think again... where putting isnull before or after the sum function.

SELECT

P.[ProgramName],

, SUM(isnull([CasesReceived],0))...

you can put a quote on the alias name eg. select dbid 'sid' from sysdatabases

if you save a dtspackage as vba file, can you re-open it in the dts gui?

you can do whatever you want in a function, update/insert/delete exec proc..etc

As long as the function returns a value.