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


Top 5 Contributors of the Month
Imran Ghani
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

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