Recently I have been checking all the Dependencies on the Reports in SSRS(Sql server Reporting Services) because of a Major deployment on the ETL. The ETL change was to accomodate the transfer of a few columns from old Table TableA to the new table TableB. Some of the Datasets in the Reports are Stored Procedures [...]
Displaying the most recent of 45 posts written by
Vivek
Recently the ETL load times of my Datawarehouse are increasing and so I decided to check the Indexes status on the tables . I found some fragmentation on the indexes and also some Statistics that are not being updated regularly . I searched online and found this blog by Ben Nevarez(SQL Blog). I decided to [...]
Recently I have read a lot of Blog posts on how to export files in different formats. But I use a custom procedure which exports text files in Pipe Delimited format using BCP.This procedure can be used in other processes for Output and Error Handling. Here is the Script for the procedure.You can modify the [...]
Many Clients have varied Requirements for Dates. You can do the conversions in Date format using T-SQL from the following link in MSDN. In reporting services you can convert datetime using the customs visual basic datetime formats using Expressions. Here are the following links on MSDN for Visual Basic Datetime Formats Predefined DateTime Formats Using [...]
If the sql server reporting services is configured on the server called “SQLBOX” then the URL is http://SQLbox/reports. If there is a named instance like SQLBOX\VIVEK then the reporting server URL is http://SQLBOX/reports_vivek
Today I stuck with an interesting problem of converting number data in Varchar fields to numeric datatypes. I have created the following sample data The data in the table contains Decimal and scientific values in varchar format as shown in the figure below. Now when I tried to convert the above values to numeric as [...]
Here are the list of Industry BI Experts and their Twitter User accounts http://spreadsheets.google.com/ccc?key=ppfitTGNfaCuf1l9u4Au4JQ
The Error Occurs when the input is date and the given day values are not in the range of the expected days for a given month(1-31) For eg. You cannot specify the date parameter as Feb 31 2009 since february only has 28 days in a non-Leap year and it throws the above error.
Storing the list of email subscribers is quite often seen in the web based companies. Once the emails are stored they are segmented based on the customer interests and products they have purchased on the website. In this article I will show the simple step of extracting the Account Name and Domain Name using T-sql. [...]
Expressions are powerful in Integration Services. With Expressions you can dynamically set the servername (based on the environment) or the name of the excel file(if it is a fixed format). Let me give you an example. I have a simple Dataflow task(as shown below) that gets the data from a table and exports it in [...]
