import excel data into multiple table through ssis
Hi All, currently i have requirement as i have import button on my front end application. when client click on that button it will browse the path of excel file and then import the data into table.remember that excel data need to fill into multiple tables.example i have 25 column of excel sheet and that...
| November 27, 2013 3:20 PM
SSIS Package 2008
I have a package with 5 data flow tasks and want to run them parallel. If any task fails, should the others still be executed and the task that failed, an email should be sent out.
| October 28, 2013 7:52 PM
, SSIS 2008
, SSIS Testing
how can make this SQL Server query faster
All, how can I make this query faster? Here is my code of stored procedure: ALTER procedure [dbo].[GetLMPReport] ( @typeId tinyint, @dataType varchar(2), @date date ) AS begin select distinct p.name, ISNULL (td24.price, 0) as '00', ISNULL (td1.price, 0) as '100', ISNULL (td2.price, 0) as '200', ISNULL (td3.price, 0) as '300', ISNULL (td4.price, 0) as...
| October 14, 2013 6:10 PM
, SQL Server 2008
, SQL stored procedures
Looking for detailed synchronization logging in SQL Server 2008
We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the detailed, timestamped...
| October 14, 2013 2:57 PM
SQL Server 2000
, SQL Server 2008
, SQL Server replication
, SQL Server synchronization
, SQL Server upgrades
, Upgrade from SQL Server 2000 to SQL Server 2008
Trying to ID SSRS reports
Our company currently has over 50 SSRS reports. We’re trying to assign an unique ID to each report and we’re wondering if there’s a way to leverage system generated information in SQL Server 2012 databases rather than manually assigning each report one-by-one.
| September 18, 2013 5:40 PM
SQL Server 2012
, SSRS reports