Expression For Extract A Substring from the given String In SSIS

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))

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

LEARNING-BI && DOWNLOADS

*********
http://www.learnmicrosoftbi.com/

**********
http://connect.microsoft.com/SQLServer

http://www.learnmicrosoftbi.com/Videos/tabid/54/Default.aspx

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

Fav Forums

SSIS2008-

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=428&SiteID=1

SSIS2005-

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

SSIS:Understanding Integration Services Package Configurations

http://msdn.microsoft.com/en-us/library/cc895212.aspx

SSIS articles, videos and samples

http://dougbert.com/blogs/dougbert/archive/2008/11/18/see-all-the-ssis-new-articles-videos-amp-samples-from-microsoft.aspx

SSIS: File System Task Move and rename files in one step

http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html

Entertainment Blogs

http://techstartups.blogspot.com/ (ENTERTAINMENT BLOG)
http://www.esnips.com (good for all free downloads)
http://www.123musiq.com (for all songs)

My favorites Blogs

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/

Here is a link to my short profile

http://www.linkedin.com/in/ravindranathreddy