Execute SSIS Package Using SQL Server Business Intelligence Development Studio (BIDS) During the development phase of the project developers can test the SSIS package execution by running the package from Business Intelligence Development Studio a.k.a. BIDS. 1. In Solution Explorer, right click the SSIS project folder that contains the package which you want to run… Read More Different ways to execute a SQL Server SSIS package
http://sqlserverpedia.com/wiki/SSIS_-_Transformations SSIS supports numerous transformations that allow you to combine data originating from multiple sources, cleanse the data and give it the shape your data destination expects. Then you can import the data into a single or multiple destinations. Transformation Description Examples of when Transformation Would be Used Aggregate Calculates aggregations such as SUM,… Read More SSIS – Transformations
Returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement. These results can be returned to the processing application for use in such things as confirmation messages, archiving, and other such application requirements. The results can also be inserted into a table or table variable. Additionally, you… Read More Output cluase – sql
SELECT * FROM (select Id, case when id >8 then Id * 2 else id end as MYID from EmpData ) Derived — this is an alias, can be XYZ WHERE MYID > 10 — we can use here a newly created column
Alter PROCEDURE dbo.EnterLoginData(@Username VARCHAR(50), @Password VARCHAR(50), @ContactNo INT, @StateName VARCHAR(50)) AS BEGIN DECLARE @StateID INT — check if state already exists IF EXISTS(SELECT * FROM dbo.DGState WHERE DG_State = @StateName) — if it exists – retrieve the DG_StateNo SELECT @StateID = DG_StateNo FROM dbo.DGState WHERE DG_State = @StateName ELSE BEGIN — if it doesn’t exists… Read More Insert FK if not present – SQL
Asp.net 2.0 step by step Membership Provider Hi, here I will configure ASP.net web application to use Membership providers. After reading this article. You will be able to perform following tasks. To speed up the performance of membership provider don’t forget to read post here http://omaralzabir.com/optimize_asp_net_membership_stored_procedures_for_greater_speed_and_scalability/ it will help you to look work on Sql… Read More Asp.net 2.0 step by step Membership Provider
SQL Server is very good at handling sets of data. For example, you can use a single UPDATE statement to update many rows of data. There are times when you want to loop through a series of rows a perform processing for each row. In this case you can use a cursor. DECLARE @MyID… Read More Cursor Basic – SQL
Sends an e-mail message to the specified recipients. The message may include a query result set, file attachments, or both. When mail is successfully placed in the Database Mail queue, sp_send_dbmail returns the mailitem_id of the message. This stored procedure is in the msdb database. MSDN link: http://msdn.microsoft.com/en-us/library/ms190307.aspx
By Using WebClient Constructor to download data from a server and display it on the system console, to download data from a server and write it to a file, and to upload form values to a server and receive the response. MSDN Link : http://msdn.microsoft.com/en-us/library/system.net.webclient.webclient.aspx http://msdn.microsoft.com/en-us/library/system.net.webclient.credentials.aspx static void Main(string[] args) { WebClient Client = new WebClient… Read More Download files from http Url – c#
Coding Strips 