SqlShare.com Logo
 
Skip Navigation Links
Login / Register
Subscribe RSS Feed 

Idera Virtual Database

Image of Brian Knight
Author:

Author Bio:
Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.
Using a Script Transform in SSIS

Using a Script Transform in SSIS

In SSIS, the data you receive from the source is rarely in the format your end users would like to see. To correct this, you can use the Script Component to transform data. In this demo, Brian shows you how to use the Script transform to make a column proper case in the data flow.

Video Information
Publish Date:
June 10, 2006
Length:
7:8
Skill Level:
300
Rating:
4.42 out of 5

Watch Video Now!  Watch it later!  

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
Ricardo on 9/10/2008
audio. No video

Deividi on 10/9/2008
very good, tks

dwaraka on 10/11/2008
nj

William Reinhold on 10/16/2008
good work

Chathura on 11/20/2008
Excellent

Kutub on 12/27/2008
Can you please provide some information about Trash destination, as i saw in video, we dont have to do any column mapping for this type of destination, hence it will be very much useful for us for learning SSIS, and develop Samples...you can mail me at qutubmumbai@gmail.com

suryavithala on 1/2/2009
good

suryavithala on 1/5/2009
Excellent

Chris on 1/6/2009
I had never used scripts in SSIS, and this helped me out tremendously and I've now got my script doing exactly what I wanted. Thanks!

Julie Moseley on 1/7/2009
omg you did it again - just what i needed

sami on 1/27/2009
good one

R on 2/1/2009
Very good video... JumpStartTV is now my fav web site... :) -R

Modi, Sanjay on 2/4/2009
Really informative

Venkata Taduri on 2/9/2009
Pretty neat.

yogi on 2/12/2009
Very helpful

Michelle Rosenaur on 2/25/2009
Great start! Makes me want to learn more.

zhong chen on 2/27/2009
I like it.

Richard H. Lang II on 3/2/2009
Thanks Brian, Exactly what I needed!

majid on 3/3/2009
was new to me. thanx

nazeer on 3/9/2009
Excellent for beginners

Nabyl Ouafi on 3/11/2009
Very nice video. Thanks a lot

Dominic Mcghee on 3/11/2009
Is there a video on how to debug the script transform task? This is where my issue is...setting it up is pretty straight forward. Good video for a someone who's never worked with SSIS though

Sam on 3/31/2009
great

fred on 4/17/2009
Excellent Video..made my life easier. Do you have a video that can split a firstname and middlename in one field into firstname and middlename into separate fields thanks

Zehra Nasif on 5/22/2009
Excellent presentation.

vin lawrence on 6/1/2009
Super as an introduction 5*'s but a more complicated example would be nicer - thanks

James Allen on 6/4/2009
good information

Christian Bahnsen on 6/5/2009
another great video. thanks so much

Kristeen Sellers on 7/13/2009
Didn't know about the Data Viewer and was bemoaning how Watches are incredibly hard to set up. THANK YOU!

Dean Gross on 8/31/2009
Is there another video that shows how to create the custom transform that was mentioned?

rupesh sharma on 9/11/2009
Excellent

172A9B06FE on 11/4/2009
Excellent once again.

Steven Hill on 11/18/2009
great concept, well presented, but was looking to script data source from custom SQL statment. :(

Tonci on 12/30/2009
Just excellent! Thank you.

Matthew Sung on 1/5/2010
exactly what i needed!

yada on 1/29/2010
I had never used the data viewer objects. Nice...

sangeeta on 2/6/2010
nicely covered script component, i like it

Arun on 2/17/2010
Excellent Article

BIUser on 2/24/2010
nice example

kiran kr on 2/26/2010
Simple, great

Jeff Olson on 3/10/2010
Thank you. I am just now wanting to learn SSIS and this video is a good start for me. (I also didn't know that ProperCase existed -- I can use that!)

Tony Gerarde on 3/25/2010
Thanks for the bacsic example to get started with.

harishkumar127 on 4/7/2010
Thank you

ranjit on 4/21/2010
not bad :D

Shobha on 6/15/2010
Excellent!! Thanks Partha

Richard Dugovic on 7/7/2010
I have watched a few of Brian Knight's SQL Server videos, and he does illustrate some fine basic scenarios. With all due respect, however, I wish that he would temper the occasional rapid-fire bursts of speech and speak just a little more clearly -- just a little. Otherwise, I think his videos are a great learning tool.



Must Be Logged In

References
4 Day SSIS class taught by Brian.

SSIS book co-authored by the speaker Brian Knight.

Using the Script Transform for Proper Casing

Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions