.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSIS dev,test,prod

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server

Hi , everybody !!!

If there are some sources how to manage dev and prod in SSIS ?


View Complete Post

More Related Resource Links

Migrating SSIS Pacakages to Prod having issues with PreValidation

The packages I migrate to Prod have Sql Server Configuration built in and Delay Validation turned on wherever it is available. The packages know what server to find the configurations by looking at the value in a global variable (ServerName) that I have created.
It works great from within Visual Studio.

When migrating to Prod, I encounter 2 issues:
1) When I build the packages, the ServerName variable and datasources are pointing to Development Servers. When the DBA attempts to set up the sql agent job in Production, the packages display an error because Production does not have visibility to the Development server. Why is it validating this? Isn't this the whole purpose of setting up configurations? How do you get around that.

2) So, I built the packages changing the server to a server that Production can see. The only server available to me is our Clone server. This server mirrors our Production server and gets refreshed once per day. So, the DBA is able to set up the sql agent job and override the Data Sources. When the job is executing it fails because the Clone server doesn't have the db objects until the next day when it is refreshed. Why is it validating the values that it was built with rather than the values that we have used to override the Data Sourc

SSIS - DB - The transaction log for database 'PROD' is full


Good day,

I get the following message "The transaction log for database 'PROD' is full" the DBA cleared it up last week and is currently on leave & and i urgently need to complete before the end of weekend.

It is a liv Database, how do i Safely clear the Transaction Log?





I have been asked to test my SSIS packages......


I have been asked to test my SSIS packages......

I found a unit testing tool on http://ssisunit.codeplex.com/ .

Is there any other formal test which I can do for an SSIS package?

Mr Shaw

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Test your skill in SQL Server

You will be given a series of 10 SQL Server related questions that are randomly selected. Since the questions are randomly selected, you will receive a different set of questions each time you start a test. At the end of the last question, you will be given your score. You can then start a new test session if you like.

Test Run: Fault Injection Testing with TestApi


Fault injection testing is the process of deliberately inserting an error into an application to determine whether it deals with the error properly. We'll explain how you can introduce faults into .NET applications at run time using the Managed Code Fault Injection APIs of the TestApi library

James McCaffrey

MSDN Magazine August 2010

Test Run: Generating Graphs with WPF


A common software-development task is generating a graph from a set of test-related data. But if you're doing it by hand and the underlying data changes frequently, this particular task can become quite tedious. James McCaffrey shows you how to automate the process using Windows Presentation Foundation technology.

James McCaffrey

MSDN Magazine June 2010

Test Run: Combinations and Permutations with F#


Understanding combinations and permutations is a fundamental skill in software testing. We show you how to work with combinations and permutations using code written in the new F# language.

James McCaffrey

MSDN Magazine May 2010

Test Run: Testing Silverlight Apps Using Messages


Silverlight greatly simplifies the process of building rich Web applications, and we'll walk through an example of using Messages as a quick method of interactively testing simple Silverlight apps.

James McCaffrey

MSDN Magazine March 2010

Test Run: WCF Service Testing with Sockets


There are many ways to test WCF services, but the socket-based approach is flexible and very useful for security and performance testing. We show you show you how to test a WCF service using a network socket based approach.

James McCaffrey

MSDN Magazine February 2010

Test Run: Web Application HTTP Request-Response Test Automation with JavaScript


Write a simple browser-based request-response test automation using JavaScript that's platform independent and useful when you are working in a highly dynamic environment.

James McCaffrey

MSDN Magazine January 2010

Generation Test: Automated Unit Tests for Legacy Code with Pex


Creating and maintaining a unit test suite for legacy code can be a challenge. Pex automatically produces a small test suite with high code and assertion coverage.

Nikhil Sachdeva

MSDN Magazine December 2009

Test Run: Pairwise Testing with QICT


In this month's column, James McCaffrey explains exactly what pairwise testing is and provides you with complete C# source code for a production quality pairwise testing tool named QICT.

James McCaffrey

MSDN Magazine December 2009

Test Run: Partial Anitrandom String Testing


This column presents an approach to Antirandom (AR) testing the author calls partial AR string testing, which can be used to test a wide range of software systems.

James McCaffrey

MSDN Magazine October 2009

Test Run: Request-Response Testing With F#


This month we show you how to use F# to perform HTTP request-response testing for ASP.NET Web applications.

James McCaffrey

MSDN Magazine July 2009

Test-Driven Design: Using Mocks And Tests To Design Role-Based Objects


Use Test-Driven Development with mock objects to design object oriented code in terms of roles and responsibilities, not categorization of objects into class hierarchies.

Isaiah Perumalla

MSDN Magazine June 2009

Test Run: .NET Module Testing with IronPython


This month we demonstrate how easy it is to use IronPython to test .NET-based libraries.

James McCaffrey

MSDN Magazine June 2009

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend