Uncategorized
-
HOW TO SEND SSRS REPORT AS EMAIL ATTACHMENT.http://mstecharchitect.blogspot.com/2009/01/how-to-send-ssrs-report-as-email.html
http://mstecharchitect.blogspot.com/2009/01/how-to-send-ssrs-report-as-email.html SSRS -SQL Server Reporting Server SQL Server Reporting Services provides access to the full functionality via Report Server Web service. The Web service uses Simple Object Access Protocol (SOAP) over HTTP and acts as a communications interface between client programs and the report server. Here is the URL to access Reporting Server… Continue reading
-
example：Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for Excel
By: Dattatrey Sindol I have read a tip on Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel, which talks about bringing in data from two or more sources into PowerPivot and storing data from each source table/query as a separate PowerPivot table. I would like to know if there is a way… Continue reading
-
The Incremental Load by T-SQL
In most data warehouse scenario, we extract data from one or multi-source and load into our centralize destination. When it comes to load data, we have two methods, one is full load and the other is incremental Load. Today I m gonna post the basic method for incremental load in T-sql. Very useful and practical.… Continue reading
-
by Ashish Kumar Mehta : Different ways to execute a SQL Server SSIS package
By: Ashish Kumar Mehta | ProblemOne of the Junior SQL Server Developers in my company approached me yesterday with a dilemma. He was developing an SSIS Package which imports data from a comma separated text file and he wanted to know the different ways in which one can execute an SSIS Package in SQL Server… Continue reading
-
SSIS: Get any flat file source from folder and cache the name as a super global veriable
Step-by-step process: On the SSIS package, create 3 variables are shown in screenshot #1. Scope CheckFilerepresents the package name. Variable Folder will represent the folder that you would like to check for the file. Filename represents the file name to check for. Variable FilePath will be the global variable that you will need. It will be filled in with the file path… Continue reading
-
SSAS Reporting Action with Date Parameters
Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want to pass in some parameters to the report so it shows the relevant data. If the parameter name matches the item in excel then this is a breeze. The problem comes when you need to… Continue reading
-
http://www.sqlservercentral.com/blogs/tim_mitchell/2014/01/20/new-blog-series-parent-child-architecture-in-ssis/
http://www.sqlservercentral.com/blogs/tim_mitchell/2014/01/20/new-blog-series-parent-child-architecture-in-ssis/ Parent-Child Architecture in SSIS Continue reading
-
how to setup SSRS in sharepoint mode
how to setup SSRS in sharepoint mode here is a Very useful instruction Continue reading
-
Multi valued Parameters using Stored Procedures in SSRS Reports – Msbi Guide
Multi valued Parameters using Stored Procedures in SSRS Reports – Msbi Guide. Continue reading
Vision Binary 