Expression For Extract A Substring from the given String
Expression:-
SUBSTRING( @[User::strPackageName] , FINDSTRING( @[User::strPackageName] , "ETL_Extract",1) + 12 , LEN( @[User::strPackageName] ) )
VB.NET Code:-
Dts.Variables("strPkgName").Value = Mid(Dts.Variables("strPackageName").Value.ToString, InStrRev(Dts.Variables("strPackageName").Value.ToString, "\", -1) + 1, Len(Dts.Variables("strPackageName").Value.ToString))
This blog provides MSBI stuff and Interview Questions. And especially you can get a lot of blog's URL on SSIS,SSAS,SSRS &MOSS From different dedicators on MSBI.If you have any queries/concerns,please feel free to contact me at->msbimaster4u@gmail.com
Tuesday, December 23, 2008
IMPORTANT BLOGS FOR SSIS,SSAS,SSRS
http://www.pinaldave.com/
http://blog.sqlauthority.com/
http://www.biblogs.com/
http://www.pinaldave.com/
http://msbissis.blogspot.com/
http://www.mahipalreddy.com/index.htm
http://www.mahipalreddy.com/blog/index.php
http://www.linkedin.com/in/padigela
http://tsutha.blogspot.com/
http://sqlblogcasts.com/blogs/tsutha/default.aspx
http://markiehillmsis.blogspot.com/
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=640277&SiteID=1 (32bit Vs 64bit)
http://www.microsoft.com/sql/bi/integrate/productinfo/foresterreport.asp
http://stevemchugh.blogspot.com/
http://sqljunkies.com/WebLog/mosha/
http://blogs.conchango.com/tags/SSIS/default.aspx
http://blogs.conchango.com/jamiethomson/default.aspx
SSIS Live Search Macro. A Live Search macro created by Jamie Thomson that covers
many SSIS relevant sites and blogs.
http://search.live.com/macros/jamiet/ssis
http://blogs.conchango.com/christianwade/default.aspx
http://blogs.technet.com/industry_insiders/archive/2008/10.aspx
http://www.bi-dw.info/blogs.html
http://www.blogcatalog.com/blogs/learnintegrationservicescom-new-ssis-tutorials-blog.html
http://blogs.conchango.com/tags/SSIS/default.aspx
http://sqlblogcasts.com/blogs/simons/default.aspx
http://sqlblogcasts.com/blogs/jorg/default.aspx
http://my-thoughts-clouds.blogspot.com/
http://wordpress.com/tag/ssis/
http://ssisblog.replicationanswers.com/
http://www.sqljunkies.com/WebLog/tpagel/archive/2005/07/24/16195.aspx
http://microsoft-business-intelligence.blogspot.com/
http://www.samuelcasanova.es/
http://blogs.microsoft.co.il/blogs/barbaro/archive/tags/SSIS/default.aspx (**********)
http://www.biblogs.com/
http://colinkirkby.blogspot.com/
http://blog.ola.hallengren.com/
www.blogcatalog.com/topic/colin-kirby/
http://vultus.stblogs.org/
http://bisqlserver.blogspot.com/ (***)
http://bisqlserver.blogspot.com/ (***)
http://blogs.msdn.com/msbi/default.aspx (*********)
http://www.microsoft.com/downloads/details.aspx?displaylang=en
http://blogs.technet.com/hayley/archive/2008/08/14/start-using-the-customer-case-studies-for-msbi.aspx
http://www.mrachek.com/ (GOOD FOR SSAS&MDX)
http://rafael-salas.blogspot.com/
http://dougbert.com/blogs/dougbert/
http://agilebi.com/cs/blogs/jwelch/
http://agilebi.com/cs/blogs/jwelch/default.aspx
http://sqlblog.com/blogs/andy_leonard/default.aspx
http://pragmaticworks.com/community/blogs/brianknight/default.aspx
http://bi-polar23.blogspot.com/
http://fishingtips.zeenvdo.com/tags/kirk-ssis/
SSAS
http://www.ssas-info.com/analysis-services-papers
http://biztalk-ssis-ssas.blogspot.com/2007/12/business-intelligence-demonstration.html
http://blog.sqlauthority.com/
http://www.biblogs.com/
http://www.pinaldave.com/
http://msbissis.blogspot.com/
http://www.mahipalreddy.com/index.htm
http://www.mahipalreddy.com/blog/index.php
http://www.linkedin.com/in/padigela
http://tsutha.blogspot.com/
http://sqlblogcasts.com/blogs/tsutha/default.aspx
http://markiehillmsis.blogspot.com/
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=640277&SiteID=1 (32bit Vs 64bit)
http://www.microsoft.com/sql/bi/integrate/productinfo/foresterreport.asp
http://stevemchugh.blogspot.com/
http://sqljunkies.com/WebLog/mosha/
http://blogs.conchango.com/tags/SSIS/default.aspx
http://blogs.conchango.com/jamiethomson/default.aspx
SSIS Live Search Macro. A Live Search macro created by Jamie Thomson that covers
many SSIS relevant sites and blogs.
http://search.live.com/macros/jamiet/ssis
http://blogs.conchango.com/christianwade/default.aspx
http://blogs.technet.com/industry_insiders/archive/2008/10.aspx
http://www.bi-dw.info/blogs.html
http://www.blogcatalog.com/blogs/learnintegrationservicescom-new-ssis-tutorials-blog.html
http://blogs.conchango.com/tags/SSIS/default.aspx
http://sqlblogcasts.com/blogs/simons/default.aspx
http://sqlblogcasts.com/blogs/jorg/default.aspx
http://my-thoughts-clouds.blogspot.com/
http://wordpress.com/tag/ssis/
http://ssisblog.replicationanswers.com/
http://www.sqljunkies.com/WebLog/tpagel/archive/2005/07/24/16195.aspx
http://microsoft-business-intelligence.blogspot.com/
http://www.samuelcasanova.es/
http://blogs.microsoft.co.il/blogs/barbaro/archive/tags/SSIS/default.aspx (**********)
http://www.biblogs.com/
http://colinkirkby.blogspot.com/
http://blog.ola.hallengren.com/
www.blogcatalog.com/topic/colin-kirby/
http://vultus.stblogs.org/
http://bisqlserver.blogspot.com/ (***)
http://bisqlserver.blogspot.com/ (***)
http://blogs.msdn.com/msbi/default.aspx (*********)
http://www.microsoft.com/downloads/details.aspx?displaylang=en
http://blogs.technet.com/hayley/archive/2008/08/14/start-using-the-customer-case-studies-for-msbi.aspx
http://www.mrachek.com/ (GOOD FOR SSAS&MDX)
http://rafael-salas.blogspot.com/
http://dougbert.com/blogs/dougbert/
http://agilebi.com/cs/blogs/jwelch/
http://agilebi.com/cs/blogs/jwelch/default.aspx
http://sqlblog.com/blogs/andy_leonard/default.aspx
http://pragmaticworks.com/community/blogs/brianknight/default.aspx
http://bi-polar23.blogspot.com/
http://fishingtips.zeenvdo.com/tags/kirk-ssis/
SSAS
http://www.ssas-info.com/analysis-services-papers
http://biztalk-ssis-ssas.blogspot.com/2007/12/business-intelligence-demonstration.html
FROM MICROSOFT FORUMS & MSDN BLOGS
*****
www.microsoft.com/bi/
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3736591&SiteID=1
http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1
http://msdn.microsoft.com/en-us/library/aa197950(SQL.80).aspx
****************
http://blogs.msdn.com/http://blogs.msdn.com/mattm/default.aspx
http://blogs.msdn.com/sqlcat/default.aspx
www.microsoft.com/bi/
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3736591&SiteID=1
http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1
http://msdn.microsoft.com/en-us/library/aa197950(SQL.80).aspx
****************
http://blogs.msdn.com/http://blogs.msdn.com/mattm/default.aspx
http://blogs.msdn.com/sqlcat/default.aspx
Entertainment Blogs
http://techstartups.blogspot.com/ (ENTERTAINMENT BLOG)
http://www.esnips.com (good for all free downloads)
http://www.123musiq.com (for all songs)
http://www.esnips.com (good for all free downloads)
http://www.123musiq.com (for all songs)
Subscribe to:
Posts (Atom)