Hi, I want to use ado.net connection manager for slowly changing dimension. I am specific about ado.net connection manager because i want to load the different in data from the on premise sql server to sql azure for an given table. If there is another alternative for this issue please advise me. Note: i can't use sync frame work 2.1 or 4.0 because of the triggers. Thanks, Jayaraj

Take a look at a CodePlex's version of the slowly changing dimensions: http://dimensionmergescd.codeplex.com/Arthur My Blog

Here are some alternatives: http://microsoft-ssis.blogspot.com/2011/01/slowly-changing-dimension-alternatives.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com