Holiday schedule for scheduled DTS Packages

I have scheduled DTS packages that I don't want to run on company
holidays. What's an easy way to do this? I have the holidays listed in
a table, but am unsure how to make the DTS fail if the current day is
in that table. Thanks!MartyNg,
You can start with an execute sql task to pull the closes holiday and put
the result into a global variable, then use an activeX task to compare that
global variable and if it is equal to today's date, then exit main function
with DTSTaskExecResult_Failure.
AMB
"MartyNg" wrote:

> I have scheduled DTS packages that I don't want to run on company
> holidays. What's an easy way to do this? I have the holidays listed in
> a table, but am unsure how to make the DTS fail if the current day is
> in that table. Thanks!
>

Ho to run Enterprise Manager on another PC

Hi,
I want to let another user access Enterprise Manager from his PC. How do I
do this? I tried to setup MMC but there is no SQL snap-in to add.
Thanks a lot, Alex.You need to install the client tools from the SQLServer CD. You are entitled
to run the client tools on any device that is licensed with a CAL or any
device that connects to a processor-licensed server.
--
David Portas
--
Please reply only to the newsgroup
--sql

hm...can`t understand, please help

i have this situations:

the aspx file with source code work good.
when i try run project which created from VS i take
"SQL Server does not exist or access denied."
connection strings same:

"Data Source=**.**.**.**,1433;Network Library=DBMSSOCN;Initial Catalog=slider;User ID=username;Password=password;"

i think may be it`s web.config in project wrong?

---

Edited by SomeNewKid
Removed username and password from connection string.first, awesome job SomeNewKid. :) Glad you snagged that. other's let that go, and cause all sorts of concern.

Anyways, there's multiple means of this happening. First, is your web.config in the root application for iis? check the domain, and examine that it's got it's own application created. Next, ping the data source including the port for the sql server. If it's a firewall issue, you're either going to have to hit a different port or pop a hole. Lastly, verify the username and password is correct by attempting to open a connection through query analyser.

If all else fails.. ctrl+a | del

:)

Higher Level Edition Error Message

Hello all,

I just installed the June CTP Client Tools on a fresh hard drive (no previous CTPs installed). I am trying to run a package that was written in the April CTP and runs successfully on other computers with the June CTP installed.

When I run the package, it fails on an 'Execute Package Task', and I get the error message:
"The task cannot run on this edition of Integration Services. It requires a higher level edition."

I know the package is okay because it runs on other June CTP computers. Did I miss something in my install? Any suggestions?

Thanks for your time,
Jessica
Did you install SSIS on the PC in question or just tools. If just the tools then that is your problem as you must install SSIS in order to run packages outside of the designer. As a workaround you can set the execute package task to run in process instead of out of process and that will also allow the package to run. We have changed the default from out of process to in process for the next CTP to try and mitigate this issue somewhat, although running outside of the designer still won't work but that is by design.

HTH,|||That was the problem!

Thanks!
Jessica

Hiding Report Parameters

I have a report with 3 parameters (Run Date, Branch, and Account Manager #).
We are using this report to show 3 different views (Corporate, Branch, and
Account Manager) and want to hide/disable the parameters that are not
required.
If the user wants to view the Corporate View, only the Run Date parameter is
to be displayed. The Branch and Account Manager # are defaulted to All using
the URL.
If the user wants to view the Branch View, only the Run Date and Branch
parameters are to be displayed. The Account Manager # is defaulted to All
using the URL.
Is it possible to hide these parameters in SQL Reporting Services 2000 using
the URL passed to the report?
If not, are there other ways?Yes. Push the report to a directory then create linked reports in 3
separate folders (corp, branch, acctMgr). You can specify whether or not
the parameter is hidden when you set up the linked report. You can then
grant the appropriate privileges on each of the three folders (don't grant
privileges to the three roles below on the primary report).
HTH
-Tim
"rwhitelaw" <rwhitelaw@.discussions.microsoft.com> wrote in message
news:FA85FF28-8F64-4FAC-80E1-8644629997CA@.microsoft.com...
>I have a report with 3 parameters (Run Date, Branch, and Account Manager
>#).
> We are using this report to show 3 different views (Corporate, Branch, and
> Account Manager) and want to hide/disable the parameters that are not
> required.
> If the user wants to view the Corporate View, only the Run Date parameter
> is
> to be displayed. The Branch and Account Manager # are defaulted to All
> using
> the URL.
> If the user wants to view the Branch View, only the Run Date and Branch
> parameters are to be displayed. The Account Manager # is defaulted to All
> using the URL.
> Is it possible to hide these parameters in SQL Reporting Services 2000
> using
> the URL passed to the report?
> If not, are there other ways?