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


Post New Web Links

SSIS integration to TFS or lack thereof

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
 
We just upgraded to TFS and SQL 2008 R2 with the hope of putting our ETL under Source Code control. No such luck. I am able to put SQL Scripts under SCC using TFS, but not ETL. It's funny that this was available with the $50 Visual Source Safe package some 8 years ago! Is it true that I'm going to have to wait until SQL 2011 Rx.


View Complete Post


More Related Resource Links

Issues with SSIS and SQL 2008 - Integration services not running

  
Hey guys, I installed SQL 2008 with complete BI studio including Integration Services. When i check in my services - i cant see my integraiton services in there When i try to connect to Integration Service using localhost, I cant connect it And when i try to run setup of SQL 2008 - It shows that Integration Services already installed and that what i checked when i fetched my Installation tool report from SQL Server to verify i have it installed. Why can i access Integration services, if i already have it, Please suggest with ideas, checks i can make to ensure every setting is in place. Thanks. Would appreciate for quick response.  

SSIS to SAP Integration

  

Hi All

 

I am new to SSIS and my first task is to find out if there are any good third party/strongly recommended connectors out there to connect to SAP.

 

Our goal is to get information from SAP using SSIS and run transformations on source data

 

Thanks


CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

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.

AppFabric Cache: Real-World Usage and Integration

  

Windows Server AppFabric provides a distributed cache for both web and desktop applications. Well show you how to integrate AppFabric caching into your apps, along with some hints for taking advantage of new cache features in the .NET Framework 4.

Andrea Colaci

MSDN Magazine June 2010


CI Server: Redefine Your Build Process with Continuous Integration

  

Jay Flowers demonstrates how to set up and use a Continuous Integration server using both discrete tools and the more comprehensive CI Factory solution.

Jay Flowers

MSDN Magazine March 2008


Agile Development: Extend Team Foundation Server To Enable Continuous Integration

  

How does Visual Studio 2005 Team System and Team Foundation Server facilitate the process of agile development and continuous integration? Here Ben Waldron explains it all.

Ben Waldron

MSDN Magazine March 2006


Service Station: SOA: More Integration, Less Renovation

  

Since the focus of this column is service-oriented architecture (SOA), I thought now might be a good time to step back and take a wide-angle look at the general concept and what it means to developers.

Aaron Skonnard

MSDN Magazine February 2005


Scripting: Windows Script Host 5.6 Boasts Windows XP Integration, Security, New Object Model

  

Windows Script Host (WSH) 5.6, a major upgrade for the WSH environment, provides some significant improvements over previous versions. A brand new security model that is tightly integrated with security in Windows XP allows administrators to place fine-grained restrictions on scripts reducing the risk from malicious code. In addition, local scripts can now run on remote machines, and enhancements to the object model reduce the amount of boilerplate code needed when writing professional code. This overview of WSH 5.6 explains these changes and how .NET and scripting work together.

Dino Esposito

MSDN Magazine May 2002


COM+ Integration: How .NET Enterprise Services Can Help You Build Distributed Applications

  

The .NET Common Language Runtime (CLR) is Microsoft's next-generation component technology. The CLR is a replacement for COM, but not for COM+. COM+, now called .NET Enterprise Services, is the Microsoft object runtime environment for scalable system development. This article explains how to implement and deploy COM+ configured classes using the CLR, how to access object context and call context, and the rules for managing context-relative object references. Also discussed are ways to manage precious resources such as data connections and pooled objects, and the relationship between COM+ and the new .NET remoting architecture.

Tim Ewald

MSDN Magazine October 2001


Pocket PC: Seamless App Integration with Your Desktop using ActiveSync 3.1

  

ActiveSync 3.1, AvantGo channels, and Internet Explorer 5.0 Mobile Links allow you to provide content for Pocket PC users over the Internet or company intranet. This article explains how to take advantage of ActiveSync and AvantGo functionality as well as how to extend ActiveSync's data synchronization capabilities by writing a custom service provider for Windows CE. The second part of the article uses eMbedded Visual C++ to develop ActiveX controls for the Pocket PC that work on both the desktop PC and on the Pocket PC platforms. Customizing the Pocket PC's Today screen using a custom Today item is demonstrated.

Dino Esposito

MSDN Magazine June 2001


BizTalk Server 2000: Architecture and Tools for Trading Partner Integration

  

This article provides an overview of the concepts involved with implementing a trading partner integration system on BizTalk Server 2000 and details the document interchange server architecture and toolset. Additionally, an early look was taken at some business process integration features planned for the production release of the product that allow easy design, execution and sharing of new business processes with trading partners. The concepts and architecture presented allow companies to prepare internal line-of-business applications and trading partners for systems that improve customer service and reduce operating costs.

Aaron Skonnard and Bob Laskey

MSDN Magazine May 2000


Design for Easy Integration into Customer's Sites

  

This is my second ASP.net project, and I'm looking for suggestions or approaches rather than specifics, but here goes.

The project, once done, will provide a "portal" into a limited portion of the client's database.  All clients are using a SQL database, but various server software products are involved (MSSQL, MySQL, and others). 

My question, however, has more to do with the "look and feel" of the finished product.  We want to be able to integrate our 'portal' easily into the client's websites and have it look as seamless as possible.  Obviously, placements of logos, etc. -- but also colors, fonts, etc.

Client sites tend to be simplistic in design.  We envision the customer placing a link to our site from theirs, and our site will be running on IIS on their server.  At least that's the plan.

The goal right now would be to make as much of this "parameter driven" as possible, so that a lot of the install can be accomplished through some simple settings, isolated in one or two files such that at installation time we can tweak those settings and be up-and-running in a short period of time with a site that integrates reasonably well with the customer's. 

But I'm uncertain as to whether there is a better approach.  Obviously, we could try to redes

Reporting Services in SharePoint integration - configurtion errors in 64bit version

  

Hi,

We have build an MOSS 2007 environment on 64 bit servers. We build the reporting services server and configured in SharePoint integration mode. Initially configuration looks fine with reporting services integration with green indicators.

 

After creating a web application and accessing the web site from the report servor, i have found the following errors:

 

Server Error in '/' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'RSSharePointSoapProxy, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot fi

using SharePoint List for SSIS package

  
I need to use a sharepoint list as data source for SSIS package, it works fine until the sharepoint site implement Kerberos only (IIS 7) authentication, anyone knows how to get around this? thanks.

Migrate DB + files outside DB into SharePoint using SSIS and scripts

  

Hello, just wanted to ask a question about SSIS and SharePoint, any input will be greatly appreciated.... did search the forum but could not find anything....

So basically we have a SQL Server DB with the metadata ONLY, WITHOUT the related files(doc/ppt/pdf..etc) which should've been in the DB and they are on a separate web server inside folders. Each row in the DB has a key (column) which matches the related folder's name, so for row with ID #112, there's a folder named ID112 on the web server with the relevant files inside. There could be more than 8+ files for one folder.  

Now, I think it is possible but just wanted to double check, would it be possible to use SSIS and some kind of a script to get the metadata inside the SQL DB AND the related files inside those folders, combine & relate them and upload them into SharePoint as a custom list with file attachments? would they display the attachment normally (like the paperclip icon in a sharepoint list...etc) I wonder if anyone has tried this...

Any guidance, thoughts, suggestions for other solutions, inputs will be great!!! Thank you!!

 

John 


HTTP 401: Unauthorized when trying to specify reporting services for integration, cannot connect to

  

Greetings.

 

I am trying to install reporting services and join it into existing service farm.

Main  MOSS 2007 is on one pc, with config bases etc, while reporting services, reporting services db will be on other pc. 

We are using same domain account to run sharepoint services and reporting services. 

I've installed web part of MOSS on that other computer, also reporting services and sql server, set reporting services in integration mode.

Either way, it wont work for me:

1)

If i am running the service of reporting services as Network Service account, then the /reportserver page will complain about some generic error "probably you dont have access to the farm if you are in integrated mode" etc.... 

I've read that i should include networkservice into a group WSS_WPG which i did, no luck anyway, same error

If i try to type the adress into the integration with reporting services in moss admin page, i will get error like "expected xml received html" and alot of red text.

2) 

If i switch service to run from domain account (the one that is used for running sharepoint on the domain) (we did the spn thing, didnt work either), the /reportserver page will open

(moss2k7/ReportServer - /

Categories: 
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