.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

How do I do this in DFT

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
Hello, Please not: I am new to SSIS and learning stuff and implementing in my project I dont see a Execute SQL Task in Data Flow. So I am reading Data Source using "OLEDB Source" - Data Access = SQL Command. Now I want to load the data to my target table. Here is what I will like to have: - Check if Record exist after I do above read. - If Exists, Truncate Target Table (OLEDB Target) and Load ALL Data - Else No Action. What transformations I sould use and how th flow should be? Thanks, Prabhat

View Complete Post

More Related Resource Links

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