Execute a data-driven SSRS subscription from SSIS to archive a report
This article demonstrates how to generate and save an SSRS report to a network folder when an SSIS package is executed.
2016-06-30
3,718 reads
ReportServer.dbo.AddEvent
Trigger an Email of an SSRS Report from an SSIS Package
This article demonstrates how to trigger an SSRS subscription to email a report from an Execute SQL Task using SQL Server Agent and the ReportServer.dbo.AddEvent stored procedure.
2015-06-19 (first published: 2013-03-19)
25,632 reads
RE: ms-access joins help
Access (Jet) SQL queries are basically the same as T-SQL, except that 'complex' queries won't work. Saying exactly what will and won't work isn't really possible.In terms of syntax, you have encountered pretty much the only two differences between Jet SQL and T-SQL. When aliasing, Access requiresthe use of 'AS', whereas for T-SQL it is optional. […]
2004-10-20
RE: DTS failed when schedualed to a job
I had a read of the article posted by Enthusiast. The security context in my case is not an issue. However the article reminds me that when I ran the package from my machine, which worked was actually ran on my machine, not the server. When schedualed to a job, it ran on server which […]
2004-10-12
RE: installing SQL server
It sounds like you've installed the software which is a good step. The sql query you have above will run on a database called "RecipesExample" and a table called "ingredients". In Sql server, you can have many databases. In each database, you can have many tables. In your tutorial/book/class documentation or notes, were there instructions […]
2004-01-20
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers