vinaykotha.blogspot.com vinaykotha.blogspot.com

vinaykotha.blogspot.com

Learn SQL BI

Tuesday, July 8, 2014. Finding out the Configuration File information for SSIS packages with in the SQL Server Agent Jobs. Select SJ.name as Job Name,. SJSstep name as Step Name,. SJSstep id as Step Num,. SJScommand as Script Command,. SUBSTRING(Command, PATINDEX('%/CONFIGFILE%', command) 13, PATINDEX('%/CHECKPOINTING%', command) - (PATINDEX('%/CONFIGFILE%', command) 15) as Config File. Inner Join sysjobs SJ. On SJS.job id = SJ.job id. Where subsystem = 'SSIS' and Command like '%/CONFIGFILE%'.

http://vinaykotha.blogspot.com/

WEBSITE DETAILS
SEO
PAGES
SIMILAR SITES

TRAFFIC RANK FOR VINAYKOTHA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

July

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

CUSTOMER REVIEWS

Average Rating: 3.6 out of 5 with 8 reviews
5 star
3
4 star
3
3 star
0
2 star
0
1 star
2

Hey there! Start your review of vinaykotha.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

Desktop Preview Tablet Preview Mobile Preview

LOAD TIME

0.1 seconds

FAVICON PREVIEW

  • vinaykotha.blogspot.com

    16x16

  • vinaykotha.blogspot.com

    32x32

  • vinaykotha.blogspot.com

    64x64

  • vinaykotha.blogspot.com

    128x128

CONTACTS AT VINAYKOTHA.BLOGSPOT.COM

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

SCORE

6.2

PAGE TITLE
Learn SQL BI | vinaykotha.blogspot.com Reviews
<META>
DESCRIPTION
Tuesday, July 8, 2014. Finding out the Configuration File information for SSIS packages with in the SQL Server Agent Jobs. Select SJ.name as Job Name,. SJSstep name as Step Name,. SJSstep id as Step Num,. SJScommand as Script Command,. SUBSTRING(Command, PATINDEX('%/CONFIGFILE%', command) 13, PATINDEX('%/CHECKPOINTING%', command) - (PATINDEX('%/CONFIGFILE%', command) 15) as Config File. Inner Join sysjobs SJ. On SJS.job id = SJ.job id. Where subsystem = 'SSIS' and Command like '%/CONFIGFILE%'.
<META>
KEYWORDS
1 learn sql bi
2 tsql
3 ssis
4 ssrs
5 ssas
6 from sysjobsteps sjs
7 posted by
8 vinay kotha
9 no comments
10 labels ssis
CONTENT
Page content here
KEYWORDS ON
PAGE
learn sql bi,tsql,ssis,ssrs,ssas,from sysjobsteps sjs,posted by,vinay kotha,no comments,labels ssis,source youtube,labels tsql,older posts,about me,blog archive,labels,sudoku puzzles,followers
SERVER
GSE
CONTENT-TYPE
utf-8
GOOGLE PREVIEW

Learn SQL BI | vinaykotha.blogspot.com Reviews

https://vinaykotha.blogspot.com

Tuesday, July 8, 2014. Finding out the Configuration File information for SSIS packages with in the SQL Server Agent Jobs. Select SJ.name as Job Name,. SJSstep name as Step Name,. SJSstep id as Step Num,. SJScommand as Script Command,. SUBSTRING(Command, PATINDEX('%/CONFIGFILE%', command) 13, PATINDEX('%/CHECKPOINTING%', command) - (PATINDEX('%/CONFIGFILE%', command) 15) as Config File. Inner Join sysjobs SJ. On SJS.job id = SJ.job id. Where subsystem = 'SSIS' and Command like '%/CONFIGFILE%'.

INTERNAL PAGES

vinaykotha.blogspot.com vinaykotha.blogspot.com
1

Learn SQL BI: Rank and ROW_Number Functions

http://vinaykotha.blogspot.com/2012/09/rank-and-rownumber-functions.html

Monday, September 10, 2012. Rank and ROW Number Functions. Subscribe to: Post Comments (Atom). View my complete profile. Rank and ROW Number Functions. Creating a Report from Analysis Services Cube. Creating a Report through Report Wizard. FTP Task in SSIS. Parallel Processing in SSIS. Variables and Expressions in SSIS. Package Configurations in SSIS. Data Viewers in SSIS. SSIS Package Configurations and Deployment to SQL . Choosing between Views, Functions and Stored Proce.

2

Learn SQL BI: Finding out the Configuration File information for SSIS packages with in the SQL Server Agent Jobs

http://vinaykotha.blogspot.com/2014/07/finding-out-configuration-file.html

Tuesday, July 8, 2014. Finding out the Configuration File information for SSIS packages with in the SQL Server Agent Jobs. Select SJ.name as Job Name,. SJSstep name as Step Name,. SJSstep id as Step Num,. SJScommand as Script Command,. SUBSTRING(Command, PATINDEX('%/CONFIGFILE%', command) 13, PATINDEX('%/CHECKPOINTING%', command) - (PATINDEX('%/CONFIGFILE%', command) 15) as Config File. Inner Join sysjobs SJ. On SJS.job id = SJ.job id. Where subsystem = 'SSIS' and Command like '%/CONFIGFILE%'.

3

Learn SQL BI: November 2009

http://vinaykotha.blogspot.com/2009_11_01_archive.html

Thursday, November 12, 2009. Using Merge Statement for Incremental Loads. Merge Statement has 5 clauses. This specifies the Target Table where Insert, Update and/or Delete operations are performed. This specifies Source, which is joined to the Target. Specifies the Join Condition. Specifies the operations to be Performed. This returns row for each row in the target object that is Deleted, Updated and/or Inserted. Note: Merge Statement always should end with Semi-Colon (;). 3) Now by using Merge Statement...

4

Learn SQL BI: September 2011

http://vinaykotha.blogspot.com/2011_09_01_archive.html

Friday, September 30, 2011. Incremental Load Using Conditional Split for SCD Type 1. As discussed in the previous blog Incremental load is one of the basic ETL designs, every day business gets new data and it has to be merged with the existing data. Loading of only the new data or new updates to the existing data is called Incremental Load or Delta. In this article we will see how to do delta load for Type 1 SCD using Conditional Split in SSIS. 3) Below screen shot showing the data in both the tables.

5

Learn SQL BI: May 2010

http://vinaykotha.blogspot.com/2010_05_01_archive.html

Wednesday, May 5, 2010. Analysis Services Overview Tips. Analysis Services Overview Tips. Subscribe to: Posts (Atom). View my complete profile. Analysis Services Overview Tips. Ethereal template. Powered by Blogger.

UPGRADE TO PREMIUM TO VIEW 5 MORE

TOTAL PAGES IN THIS WEBSITE

10

OTHER SITES

vinaykitchentrolley.com vinaykitchentrolley.com

Vinay Kitchen Trolley, Aurangabad MH, Manufacturer of Sofa Set , Bed, wall mounted shoe rack, Wardrobes, Kitchen Trolleys,

A Hemant Deshpande Unit. Wall mounted shoe rack. Wall mounted shoe rack. Add to my kard collection. Entire Vinay’s Staff is waiting for your visit, eagerly! Whether it be a Kitchen Trolley, or Whole Kitchen we custom- make it as per choice, need and budget of the customer. The beauty, quality, and service will win your heart. Try it! Motto: Innovation, Quality and Prompt Service are the pillars of our success. A Hemant Deshpande Unit. Wall mounted shoe rack. Key Products We Sell:.

vinaykmittal.blogspot.com vinaykmittal.blogspot.com

Bioinformatics blog

On this blog, I share my thoughts on the next-generation sequencing data analysis related issues and problems that I (or you may) have come across at some point of time.I hope you find it useful. Wednesday, July 22, 2015. RNA-Seq expression metrics: FPKM, RPKM and TMP explained by StatQuest. For text summary please refer to: StatQuest page. Links to this post. New ovarian cancer study on large structural variants based on TCGA data is out. Here is the brief summary:. First we designed an integrated bioin...

vinayknl.blogspot.com vinayknl.blogspot.com

Something to think about

Something to think about. Saturday, December 27, 2008. I got 5 million . I got 5 million dollars … What to do next? Let me start with a little background about the money I am talking about. A big question……. Now time to spend my money …. What to do with it? Later, a new idea came in. Let me buy some property which gives a good return while I can sit and enjoy its returns throughout my life time and fulfil my dreams of visiting as many countries as possible. But…. Hold on …. Ev...What will happen with my ...

vinaykola.com vinaykola.com

Infinite Improbability

Random thoughts that run through my head, stories about my life and ideas about software programming. Page 1 of 1. Proudly published with Ghost.

vinaykoshy.com vinaykoshy.com

vinaykoshy.com - Registered at Namecheap.com

This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! The Sponsored Listings displayed above are served automatically by a third party. Neither Parkingcrew nor the domain owner maintain any relationship with the advertisers.

vinaykotha.blogspot.com vinaykotha.blogspot.com

Learn SQL BI

Tuesday, July 8, 2014. Finding out the Configuration File information for SSIS packages with in the SQL Server Agent Jobs. Select SJ.name as Job Name,. SJSstep name as Step Name,. SJSstep id as Step Num,. SJScommand as Script Command,. SUBSTRING(Command, PATINDEX('%/CONFIGFILE%', command) 13, PATINDEX('%/CHECKPOINTING%', command) - (PATINDEX('%/CONFIGFILE%', command) 15) as Config File. Inner Join sysjobs SJ. On SJS.job id = SJ.job id. Where subsystem = 'SSIS' and Command like '%/CONFIGFILE%'.

vinaykrishna.blogspot.com vinaykrishna.blogspot.com

In This Beautiful World...

In This Beautiful World. Tuesday, February 04, 2014. When Sachin Tendulkar retired. I was away from Internet when he retired in November but today as he received the ultimate honour,. It’s sinking in. We, the kids from 80s, grew up with Sachin. That signature straight drive. Was one of the highlights of growing up days. Etched forever in memory. Our hearts have a special compartment for him, for when be batted,. We felt like God. So when Sachin Tendulkar retired, may be it’s not just him…. But not our ve...

vinayksharma.com vinayksharma.com

Enter - Vinay Sharma

vinaykumar.biz vinaykumar.biz

Vinay Kumar – Internet Marketer & Coach

Discover the Easiest Way. To Create Unstoppable Income in 2017. Today is Your Day to Choose Your Road For Success or Failure. Download My eBook for FREE. Download the Free Book. Sign up to get instant access to my special report get exclusive weekly upates! 2017 by vinaykumar.biz.

vinaykumar.info vinaykumar.info

Vinay kumar UI Developer