Thanks for the additional insight!  This is also good to know!

Thanks for the replies.  I'll pass along that I've confirmed the dependency.  They'd like to have it run weekly, so I like the thought that they could start up/shut down...

After wrestling with this issue for several hours, I solved it by moving the vb.net function into the report's code property and adding the system.xml to the assembly references. ...

Good to see you learned some new acronyms flo :-D:-D

Thanks for all the different perspectives.

I didn't know that a SELECT that returns multiple rows would give you the last value. It sounds a bit scary to...

Thanks for the feedback folks. I should try breaking the old habit too. 😀

guess that I should have posted this as a poll. 🙁

I usually use something like...

CHARINDEX(@valuetosearchfor,ColumnToSearch) > 0

Like Flo said, stick to the existing thread, or get a book.

I posted a reply there

I usually do a replace() on char 10, 13, 20, 0 or whatever needs to be done.

I agree that output parameter would be the lean way to go.

I've always used temp tables to return a recordset in those cases, must be an old habit...

Try setting your textbox layout property canshrink/cangrow to true. and set the height to zero for the row.

We've asked the DBA to follow the specified security changes in the KB article, but were told that the article does not apply. It only applies to jobs being...

We know that the connection string gets populated into the variable because the first child package runs. Operations execute as follows...

1) writes to event log table via child package

2)...

OK, so we turned all possible references of DelayValidation to true in the packages as well as the control flow components. The command we are using to reference the...