|
|
|
|
 |
SQL Server Reprting Services (SSRS) Report Design Tips and Tricks
|
| Total Hit (3859) |
This white paper covers best practices on report design and helps you avoid common mistakes when choosing a report layout and output format. Take advantage of existing product features to achieve the results you want. The paper includes report and code examples that implement functionality that is f
....Read More |
Rating
 |
|
|
|
How to create Format File using BCP command
|
| Total Hit (22040) |
When you bulk import into a SQL Server table or bulk export data from a table, you can use a format file to store format information for each field in a data file relative to that table. A format file provides a flexible system for writing data files that requires little or no editing to comply with
....Read More |
Rating
 |
|
|
|
How to find start/end date of Previous Quarter
|
| Total Hit (3345) |
«code LangId=6»declare @PrevQtrDate datetime
declare @PrevQtrStartDate datetime,@PrevQtrEndDate datetime
declare @ReportDate datetime
set @ReportDate=getdate()
set @PrevQtrDate=dateadd(q,-1,@ReportDate)
Print @PrevQtrDate
set @PrevQtrStartDate=cast(month(@PrevQtrDate) as varchar(10)) + '
....Read More |
| Rating
|
|
|
|
Displaying RTF formatted text in SQL 2005 Reporting services
|
| Total Hit (43972) |
I haven't tried this but it may be helpful to someone who is trying to display RTF formatted text on their report. Crystal Report Support RTF/HTML format but RS 2005 doesnt support. May be MS will add in the next release.
Just follow these steps:
Compile the code below it into a class
Firs
....Read More |
Rating
 |
|
|
|
|
|
|
|
|
|
|
|
Accessing OLEDB Connection Managers in a SSIS Script Component
|
| Total Hit (14223) |
Sometimes you may need to access OLEDB Connection Manager to execute Queries in Script. Here is the easy way to do that.
Credit : http://blogs.msdn.com/mattm/archive/2008/08/22/accessing-oledb-connection-managers-in-a-script.aspx
«code LangId=2»
Imports System
Imports System.Data
Imports
....Read More |
Rating
 |
|
|
|
|
|
How to pass array to stored procedure in SQL Server
|
| Total Hit (4015) |
Have you ever come across the situaction when you have to pass mutiple values as parameter to your stored procedure.
Assume the following scenario.
- Your application pass comma seperated CustomerID list to stored procedure to get Orders for related customers.
Above requirement can be don
....Read More |
Rating
 |
|
|
|
Script - Update Blank Values of Group until Next group starts
|
| Total Hit (2641) |
Recently I came across simple scenario where I had to update some blank values of certain records. Here is what i mean
Assume you have two columns. You want to update Order# column with same order number until next group starts (e.g. ID 2,3 update with Order# => 1000).
ID Order#
1 1000
2
....Read More |
| Rating
|
|
|
|
Building SSIS Packages Programmatically (Part 1 to Part 9)
|
| Total Hit (4582) |
This tutorial series will show you how to use SSIS Object Model to buil packages programatically in C# (or VB.net)
<a target=_blank href='http://www.ssisbi.com/2009/01/14/building-ssis-packages-programmatically-part-1/'>http://www.ssisbi.com/2009/01/14/building-ssis-packages-programmatically-part
....Read More |
| Rating
|
|
|
|
Creating a custom task with a default UI
|
| Total Hit (1442) |
The Developing a User Interface for a Custom Task entry in Books Online describes how to build your UI from scratch, but there is an easier way to create a UI that has the same look and feel as the stock tasks that ship with SSIS.
The Microsoft.DataTransformationServices.Controls assembly expose
....Read More |
| Rating
|
|
|
|
Programming Conditional Split Transformation
|
| Total Hit (1411) |
There may be some circumstances in a sanctuary where it becomes necessary to keep a leash of foxes and a pack of wolves separate so that they must not fight with each other and make things a mess. Similarly, in the database jungle we do the same things by using some conditional statements in order t
....Read More |
| Rating
|
|
|
|
|
|
Read DTS and SSIS Packages Programatically.
|
| Total Hit (1377) |
Reading a DTS/SSIS programmatically helps a lot in doing impact analysis. Consider a scenario in which all the packages containing a particular table or stored procedure need to identified. Let me give another usage scenario for this. The sql native clinet provider SQLNCLI.1 is no longer supported i
....Read More |
| Rating
|
|
|
|
Supporting DTS in SQL Server 2005
|
| Total Hit (945) |
Supporting DTS packages in SSIS ( SQL Server Integration Services ) is a daunting task for many. Let’s look at what you need to get the job done and get some good tutorials on the subject.
|
| Rating
|
|
|
|
Coping with No Column Names in the SSIS OLEDB Data Source Editor
|
| Total Hit (862) |
Sooner or later you'll create a DataFlow and come across this type of dialog box for the OLE DB source:
So, why does this problem occur, when all previous attempts have worked? Well the most likely case is that you are selecting from a temporary table as the last statement in the source stored pr
....Read More |
| Rating
|
|
|
|
|
|
|
|
Scanning the network for SQL Server for a range of IP addresses
|
| Total Hit (936) |
In a large IT department, it can be difficult to locate where new SQL Server installations were made and how many of those SQL Servers were patched, etc. This article explains how to scan the entire network for a range of IP addresses to find which boxes have SQL Server instances installed. The OSQL
....Read More |
| Rating
|
|
|
|
|
|
How to Decipher/Understand SSIS Error Code?
|
| Total Hit (957) |
If you have worked with SSIS, you may have been doing something like this, in case of errors, you saved the error code and the error column to a text file or some other media.
|
| Rating
|
|
|
|
|
|
|
|
|
|
Understanding BCP/BULK COPY Format Files
|
| Total Hit (1144) |
In Microsoft SQL Server 2000 and earlier, bulk exporting and importing works with a single type of format file. This is supported in Microsoft SQL Server 2005. SQL Server 2005 also supports XML format files as an alternative. To distinguish format files of the original type, they are called non-XML
....Read More |
| Rating
|
|