Programming Zone

    Programming ZONE

 
Article Author:
It's a problem I'm sure many of you have faced in developing web applications. You've got a form to add a new something - perhaps a customer or an item in a to-do list. When the user clicks that link to add a new item, a new page loads, they fill in the data, hit save, and then get re-directed back to the original page. Wouldn't it be easier if they clicked that link and the form opened in a modal dialog instead, allowing them to quickly enter their information and hit save without ever having to move from page to page? Now many of you are probably saying "Yah, that's easy, just create a div on your page, put the form in there, and make that your dialog." Well that's great, but what if you're ...
Article Author:
Suppose you encounter the following scenario:


You have a source database table and destination database table, you want to transfer rows from source destination so you decide to use the SSIS data flow task with an OLE DB source and OLE DB destination. When you run the task, an error occurs when destination table has a few rows inside, and there is Unique Constraint in ID field of Destination table.
In this situation your data flow will fail, because when OLE DB Destination want to insert rows in destination table, it will lead...
Article Author:
In a previous article I've shown you how to import data from an Excel sheet using the OPENROWSET() function. And I concluded by stating that it's not the best option when automating your data import.

Today I'll repeat the Excel data import process by using SQL Server Integration Services, also known as SSIS.

I'll be using SQL Server 2008 R2, but I'm quite sure that the process is very similar to the first release of 2008, and even to 2005. The Excel file that I will be importing is the one used in my previous article, and I'll also refer to some ...
Article Author:
Sometimes, you need to use PIVOT in SSIS to ensure your data matches the output requirements of your users. So, what is PIVOT and what is SSIS and how can that help ?

Firstly a quick explanation of those acronyms as described by Microsoft :

Microsoft SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including the extraction, transformation, and loading (ETL) of packages for data warehousing. SSIS is the new name assigned to the component formerly branded as ...
 
 
Must Read
 
 
Zone Advisors

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
 
2000th Corporate Account

2000 organizations, including eBay, Ericsson, and Lockheed Martin, now work smarter with Corporate Accounts. Save over 36%!

 
 
[x]
Neglected Question
Neglected questions are any questions that either have not yet been addressed by an expert, or a solution has not been awarded, and may be eligible for bonus points (see your profile page for details).
Filter: Date
rrjegan17 posted an expert comment! Enhanced Backup and Restore 07/31/10 06:05 AM
rrjegan17 posted an expert comment! SQL Server express edition restore folder 07/31/10 06:05 AM
capricorn1 posted an expert comment! Issues with Value List in Table ver 07 or 10 07/31/10 06:04 AM
whosbetterthanme posted an expert comment! Perl start .bat window base 07/31/10 06:03 AM
FishMonger posted an expert comment! Perl start .bat window base 07/31/10 05:57 AM
Darksquire posted an expert comment! SQL 2005 Server connecting to Oracle for data source 07/31/10 05:57 AM
Darksquire posted an expert comment! Where can I find nice deals on Laptops at whole sale prices? 07/31/10 05:55 AM
amenkes posted an expert comment! Is it possible to databind within the UI from a background thread? 07/31/10 05:54 AM
MikeOM_DBA posted an expert comment! Needs Shell script for diskgroup utilization in RHEL 4 ASM 07/31/10 05:53 AM
Chinmay_Patel posted an expert comment! Entity view in HTML Email IFrame 07/31/10 05:53 AM
View More
 
 
 
Loading Advertisement...
ADVERTISEMENT