Hi,

I never did a task like this but here are my thoughts about it 🙂

Since you load data from a source database to a new schema maybe it's an idea...

Hi,

in profiler you could create a new trace, select the event SQL:Batchcompleted only and setup a column filter for the column TextData (filter like %update%).

So you'll get only the update...

Hi,

you need two percent signs for your variable. (%%f instead of %f)

Hope this helps 🙂

Hi,

I played around with your question. Unfortunately I don't know an easy solution...but this one could work for you.

declare @dates varchar(1000) = ''

select @dates = @dates + ',' + '['...

Hi,

try this:

select memberid, AVG(labvalue)

FROM

(

Select Memberid

, labvalue

, ROW_NUMBER() OVER (PARTITION BY MemberID ORDER BY LabDate DESC) RowNum

From MemberLabResult

WHERE...

Hi,

you can create a job step with type "Operating System (cmdexec)" and call your C# program.

Hope this helps 🙂

If you want to insert the variable used in the for loop container you could use a "Execute SQL Task"-task.

In the attached screenshots you can see how to configure this...

Hi,

if you know one parent table you can get all dependencies with the attached script (captured from sql server profiler). (the parent table is in line 15)

Maybe it helps as...

Hi,

as far as I know you can't do this in the object explorer directly. But have a look at the "job activity monitor" under the "SQL Server Agent" node.

There you...

Hi,

if you don't care which values from column1 and column2 you get you could use this query:

select id, max(column1) as maxcol1, max(column2) as maxcol2

from yourtable

group by id

Hope this helps...

Hi,

to find a string in a job step you could use this query:

use msdb

select * from sysjobsteps

where command like '%your_old_server_name%'

To find the SSIS-Packages referencing your old server you could try...

Hi,

you must configure all of your packages with these steps to use the variable for all of them.

Regards.

Hi you do not have to "call" this variable in your send mail task. Your send mail task is connected with the configured smtp connection manager.

When you've made steps 3...

Hi,

1. Create a SMTP Connection Manager eg. "StandardMail"

2. Create an environment variable (on the server where the packages are running) with the name eg. "StandardSMTP" and the value

3....

Hi,

to check more than one job you could read the job names from a table. Or you could define the jobs to check in the script and check one after...