Scheduling Tasks

In Data Transformation Service, Local Packages,
I need to pull data from a SAGE Line 50 v9 database into SQL . I have
created a simple DTS Package to pull one of the tables and prove the concept
.
It is set
up so it drops the existing table, creates it again and then copies
the data across. It runs well when I run it as a package, however it
fails when I run it as a scheduled job.
It seems to drop the table, it then creates the table (this somehow tells me
that I
don't have a permissions problem because the table structure has to be
read from the SAGE database), but finally fails to copy the data.
Error
Step Error Description:The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
(80004005): Cannot find all files in data path)When you run a package interactively, it runs under YOUR permissions. When
you schedule a package it runs under the permissions for the login that SQL
Agent uses... Make sure the SQL Agent login has the appropriate permissions
everywhere
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> In Data Transformation Service, Local Packages,
> I need to pull data from a SAGE Line 50 v9 database into SQL . I have
> created a simple DTS Package to pull one of the tables and prove the
concept.
> It is set
> up so it drops the existing table, creates it again and then copies
> the data across. It runs well when I run it as a package, however it
> fails when I run it as a scheduled job.
> It seems to drop the table, it then creates the table (this somehow tells
me
> that I
> don't have a permissions problem because the table structure has to be
> read from the SAGE database), but finally fails to copy the data.
> Error
> Step Error Description:The driver returned invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
> (80004005): Cannot find all files in data path)|||Thanks Wayne Spot on
"Wayne Snyder" wrote:

> When you run a package interactively, it runs under YOUR permissions. When
> you schedule a package it runs under the permissions for the login that SQ
L
> Agent uses... Make sure the SQL Agent login has the appropriate permission
s
> everywhere
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
> news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> concept.
> me
>
>sql

Scheduling Tasks

In Data Transformation Service, Local Packages,
I need to pull data from a SAGE Line 50 v9 database into SQL . I have
created a simple DTS Package to pull one of the tables and prove the concept.
It is set
up so it drops the existing table, creates it again and then copies
the data across. It runs well when I run it as a package, however it
fails when I run it as a scheduled job.
It seems to drop the table, it then creates the table (this somehow tells me
that I
don't have a permissions problem because the table structure has to be
read from the SAGE database), but finally fails to copy the data.
Error
Step Error Description:The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
(80004005): Cannot find all files in data path)When you run a package interactively, it runs under YOUR permissions. When
you schedule a package it runs under the permissions for the login that SQL
Agent uses... Make sure the SQL Agent login has the appropriate permissions
everywhere
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> In Data Transformation Service, Local Packages,
> I need to pull data from a SAGE Line 50 v9 database into SQL . I have
> created a simple DTS Package to pull one of the tables and prove the
concept.
> It is set
> up so it drops the existing table, creates it again and then copies
> the data across. It runs well when I run it as a package, however it
> fails when I run it as a scheduled job.
> It seems to drop the table, it then creates the table (this somehow tells
me
> that I
> don't have a permissions problem because the table structure has to be
> read from the SAGE database), but finally fails to copy the data.
> Error
> Step Error Description:The driver returned invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
> (80004005): Cannot find all files in data path)|||Thanks Wayne Spot on
"Wayne Snyder" wrote:
> When you run a package interactively, it runs under YOUR permissions. When
> you schedule a package it runs under the permissions for the login that SQL
> Agent uses... Make sure the SQL Agent login has the appropriate permissions
> everywhere
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
> news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> > In Data Transformation Service, Local Packages,
> > I need to pull data from a SAGE Line 50 v9 database into SQL . I have
> > created a simple DTS Package to pull one of the tables and prove the
> concept.
> > It is set
> > up so it drops the existing table, creates it again and then copies
> > the data across. It runs well when I run it as a package, however it
> > fails when I run it as a scheduled job.
> > It seems to drop the table, it then creates the table (this somehow tells
> me
> > that I
> > don't have a permissions problem because the table structure has to be
> > read from the SAGE database), but finally fails to copy the data.
> >
> > Error
> > Step Error Description:The driver returned invalid (or failed to return)
> > SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
> > (80004005): Cannot find all files in data path)
>
>

Scheduling Tasks

In Data Transformation Service, Local Packages,
I need to pull data from a SAGE Line 50 v9 database into SQL . I have
created a simple DTS Package to pull one of the tables and prove the concept.
It is set
up so it drops the existing table, creates it again and then copies
the data across. It runs well when I run it as a package, however it
fails when I run it as a scheduled job.
It seems to drop the table, it then creates the table (this somehow tells me
that I
don't have a permissions problem because the table structure has to be
read from the SAGE database), but finally fails to copy the data.
Error
Step Error Description:The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
(80004005): Cannot find all files in data path)
When you run a package interactively, it runs under YOUR permissions. When
you schedule a package it runs under the permissions for the login that SQL
Agent uses... Make sure the SQL Agent login has the appropriate permissions
everywhere
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> In Data Transformation Service, Local Packages,
> I need to pull data from a SAGE Line 50 v9 database into SQL . I have
> created a simple DTS Package to pull one of the tables and prove the
concept.
> It is set
> up so it drops the existing table, creates it again and then copies
> the data across. It runs well when I run it as a package, however it
> fails when I run it as a scheduled job.
> It seems to drop the table, it then creates the table (this somehow tells
me
> that I
> don't have a permissions problem because the table structure has to be
> read from the SAGE database), but finally fails to copy the data.
> Error
> Step Error Description:The driver returned invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
> (80004005): Cannot find all files in data path)
|||Thanks Wayne Spot on
"Wayne Snyder" wrote:

> When you run a package interactively, it runs under YOUR permissions. When
> you schedule a package it runs under the permissions for the login that SQL
> Agent uses... Make sure the SQL Agent login has the appropriate permissions
> everywhere
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
> news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> concept.
> me
>
>

scheduling sms through sql server

hai to every one,

pls,help me "How to schedule Short message service to mobile phone using SQL server".Need help as soon as possible..........

See this related post...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1541109&SiteID=1

Short answer:

You can use Database Mail to send an email to your carrier's SMS gateway. If you want to schedule this, you can use SQL Server Agent.

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

Scheduling an SSIS package that invokes a web service

Hey,

I have an SSIS package that invokes a web service and then updates a table. It runs fine as long as I am running it on the local machine. However, as soon as I save this package to the sql server, and try to schedule this as a job, it starts to fail. Now, the web service writes to an xml file and also uses an xsd and and an xsl file. When I save a dts package to the sql server, whats the proper way of referencing these files? I think this probably is what is making the package to fail, ut I am not sure.

Any help is greatly appreciated!!

Thanks!

You should use a configuration (right-click in the package and choose configurations) to set the ConnectionString property of the connection managers for the files. Or you could use expressions to set the connection strings (paths and filenames) based on variables. The variables can be set at runtime using the /SET option of DTEXEC.|||Also make sure you've configured SSIS logging, so you can find out why the package fails now or (once you fix the problem and go to production) if something goes wrong with scheduled package in production.|||That depends on where you want to keep them. I prefer to keep them in files on the disk. If your package is in SQL and you prefer to avoid the disk entirely, you can keep them in the database and just load them into variables via the Execute SQL task. The XML task and the XML Source component support receiving the XSD/XSLT from variables.
|||Thanks a lot for the suggestions. I will try them out and see how it works.|||

Hey,

Sorry for this delayed reply. Since I posted this question a lot of issues cropped up with my SQL server which eventually led to a total reinstallation of all apps on my pc. Anyway, I discovered that the problem I have been having was because of permission issues. I was able to fix that problem and just when I thought that I had everything going, I came across a new problem. After I save the SSIS package in sql server and create a job, the job starts failing. This is the error that I am getting:

-1073548540,0x,An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: Unable to connect to the remote server.

Any suggestions would be very helpful.

Thanks!

|||Could it be a authentication issue? Is there any security on the web service?|||

Guys!!Thanks a lot for all the suggestions. Really appreciate your help. Problem was a combination of many issues. One was related to 32bit/64bit differences, the other was authentication, and finally some syntax problems when invoking the web service. Seems it is working really well now.

Thanks again!

Scheduled Tasks for SQL 7.0

Is there a way to schedule a task to shutdown SQL server, run a backup and
restart the service after the backup is finished?
can use the AT scheduler for this but why not backup the database and then
schedule the backup software using sqlserveragent to backup the backup file
as a subsequent step to the database backup?
"Margo" <margo@.discussions.microsoft.com> wrote in message
news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
> Is there a way to schedule a task to shutdown SQL server, run a backup and
> restart the service after the backup is finished?
|||Is there any documentation on this procedure that I could follow?
"Olu Adedeji" wrote:

> can use the AT scheduler for this but why not backup the database and then
> schedule the backup software using sqlserveragent to backup the backup file
> as a subsequent step to the database backup?
> "Margo" <margo@.discussions.microsoft.com> wrote in message
> news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
>
>

Scheduled Tasks for SQL 7.0

Is there a way to schedule a task to shutdown SQL server, run a backup and
restart the service after the backup is finished?can use the AT scheduler for this but why not backup the database and then
schedule the backup software using sqlserveragent to backup the backup file
as a subsequent step to the database backup?
"Margo" <margo@.discussions.microsoft.com> wrote in message
news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
> Is there a way to schedule a task to shutdown SQL server, run a backup and
> restart the service after the backup is finished?|||Is there any documentation on this procedure that I could follow?
"Olu Adedeji" wrote:

> can use the AT scheduler for this but why not backup the database and then
> schedule the backup software using sqlserveragent to backup the backup fil
e
> as a subsequent step to the database backup?
> "Margo" <margo@.discussions.microsoft.com> wrote in message
> news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
>
>

Scheduled Tasks for SQL 7.0

Is there a way to schedule a task to shutdown SQL server, run a backup and
restart the service after the backup is finished?can use the AT scheduler for this but why not backup the database and then
schedule the backup software using sqlserveragent to backup the backup file
as a subsequent step to the database backup?
"Margo" <margo@.discussions.microsoft.com> wrote in message
news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
> Is there a way to schedule a task to shutdown SQL server, run a backup and
> restart the service after the backup is finished?|||Is there any documentation on this procedure that I could follow?
"Olu Adedeji" wrote:
> can use the AT scheduler for this but why not backup the database and then
> schedule the backup software using sqlserveragent to backup the backup file
> as a subsequent step to the database backup?
> "Margo" <margo@.discussions.microsoft.com> wrote in message
> news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
> > Is there a way to schedule a task to shutdown SQL server, run a backup and
> > restart the service after the backup is finished?
>
>

Scheduled reports not working - service account

Hi
I'm just getting my feet wet with Scheduled reports in SSRS2005, and have
hit a snag...
The schedule is not working, and when I check the job history on SQL Server
I find the message:
'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
SERVICE'. The step failed.
I find if I go into Management Studio, I can change the NETWORK SERVICE to a
domain user account, and everything works - but then I can't change the
subscription properties from Report Manager.
SQL Server & SSRS are both running on Windows Server 2003 under a domain
account, and the data/SSRS connection points to an SQL Server 2000 Database
on a different server in the domain.
Any ideas? I've gone through the security recommendations and still can't
find a solution.
Regards
GrantHi
Don't worry about responding to this one - I figured it out...
Fixed it by setting everything to use the NetworkService account, except for
the SQL Agent - I found one of my mistakes was changing the account from the
Service Manager, instead of the SQL Server Configuration Manager.
Anyway - all is well and reports are running as scheduled.
Thanks
Grant
"Grant Morgan" <grantmorgan@.noemail.noemail> wrote in message
news:ujq4Jos3GHA.696@.TK2MSFTNGP03.phx.gbl...
> Hi
> I'm just getting my feet wet with Scheduled reports in SSRS2005, and have
> hit a snag...
> The schedule is not working, and when I check the job history on SQL
> Server I find the message:
> 'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
> SERVICE'. The step failed.
> I find if I go into Management Studio, I can change the NETWORK SERVICE to
> a domain user account, and everything works - but then I can't change the
> subscription properties from Report Manager.
> SQL Server & SSRS are both running on Windows Server 2003 under a domain
> account, and the data/SSRS connection points to an SQL Server 2000
> Database on a different server in the domain.
> Any ideas? I've gone through the security recommendations and still can't
> find a solution.
> Regards
> Grant
>
>

Schedule and Delivery Processor Error

I am having issues with getting our Development Report Services Server to
schedule any reports to run. Recently, I had to change our service account
to a non-expiring one and now I get the following in our Event Log.
Schedule and Delivery Processor
Failed to decrypt symmetric key. Most likely cause is the serivce username
has changed.
Our setup is as follows:
W2K3 Web Server (running Reporting Services) and a seperate SQL 2000
Enterprise Server housing the Reporting Services database. I have run the
rsconfig and the rsactivate after changing the service account which
completed successfully.
Does anyone have any suggestions, short of totally reinstalling, to get this
error corrected and the scheduler working?
Thanks,
Greg QuinnI answered my own question. By running the rskeymgmt utility with the -d
flag I was able to delete all encrypted information from the reporting
services database and then ran the rsactivate and then reapplied the
datasources, parameters and schedules. Now everything appears to be working
correctly.
"Gregory C. Quinn, Jr." <gquinn@.yadtel.net> wrote in message
news:11vpjatmrfu45d2@.corp.supernews.com...
>I am having issues with getting our Development Report Services Server to
>schedule any reports to run. Recently, I had to change our service account
>to a non-expiring one and now I get the following in our Event Log.
> Schedule and Delivery Processor
> Failed to decrypt symmetric key. Most likely cause is the serivce username
> has changed.
> Our setup is as follows:
> W2K3 Web Server (running Reporting Services) and a seperate SQL 2000
> Enterprise Server housing the Reporting Services database. I have run the
> rsconfig and the rsactivate after changing the service account which
> completed successfully.
> Does anyone have any suggestions, short of totally reinstalling, to get
> this error corrected and the scheduler working?
> Thanks,
> Greg Quinn
>