SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite 8

Loading Binary Files into SQL Server Using SSIS

Binary objects like Word documents, MP3 files, or any other non-data file can be challenging to load into SQL Server. In this presentation, Brian shows you how to use SQL Server Integration Services (SSIS) to load BLOB resume files into SQL Server by using the Import Column transform.

Duration:
7 mins 2 secs
Skill Level:
300
Rating:
4.44 out of 5
Publish Date:
December 05, 2006
Loading Binary Files into SQL Server Using SSIS You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Brian Knight
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.

References



Comments
Don Hampton on 9/25/2008
Excellent!

Pat on 11/10/2008
great video

Volker on 11/19/2008
Right to the point - perfect!

olivier on 11/20/2008
Exactly what I was looking for. Thanks a lot

shar on 12/7/2008
too good crystal clear loved the video neatly presented hats off thanks so much sharon

Jay Rhee on 3/19/2009
This is great video to fix my issue

jayraj0071 on 4/7/2009
One of the best videos i have ever seen regarding ssis

Phil Parkin on 4/29/2009
Very clear and concise - excellent work.

Gina Meronek on 5/4/2009
One part was confusing - what was the significance of setting those two properties to "53"? Wasn't sure what that meant.

Gina Meronek on 5/4/2009
One part was confusing - what was the significance of setting those two properties to "53"? Wasn't sure what that meant.

Gina Meronek on 5/4/2009
Great topic! What's the significance, though, of setting the property to 53? What is that integer from?

jayraj0071 on 5/17/2009
jumpstart tv videos are superb

Raul Salcedo on 5/19/2009
Excellent video presentation, I only have a trouble with the resultset parameter of the SQL task, that must to be none in this case.

Kiran on 6/16/2009
thats very good

Ivan on 6/21/2009
It's a nice howto. Thnks a lot.

James Moore on 7/27/2009
Excellent! Thank you very much for your time putting these videos together.

Chrystal on 9/1/2009
Very useful!! I love the presentation!

Suchu on 9/6/2009
thanks

Chris Williams on 10/2/2009
Love IT!

Alex on 10/14/2009
Very helpful and to the point thanks

Karen on 11/9/2009
i really needed this!

robert on 11/24/2009
More ssis! Thanks

Tim on 12/11/2009
Excellent video.

Brian Savoie on 12/13/2009
Can't tell you how much I love your work folks!!

Mick on 12/15/2009
Can anyone correct this code - its at 3:08 in the video. The video isn't crystal clear, and I can't make out what the code is actually trying to do: "Insert into DOC_Stage (FileName, FilenameShort) Values ('" + replace (right(@(User::strFileName), 10, ".doc", "") + '","' + @(User::strFileName)+ '")"

Tonci on 12/23/2009
Great work! Thank you.

Monty on 2/9/2010
Great first steps video. I am trying to learn how to take advantage of teh SQL 2008 FileStream option and this gives me an idea of how to approach the problem.

nirmal on 3/11/2010
Really great video, this solved my problem what I was looking for.

aman on 3/15/2010
Brian..This is great video.I was trying to load Images using SSIS. Any ideas or an example would be highly appreciated....

Brain great video just what I need. One question when I look at the Resume table I get <Binary Data> in the blob field. Do I need to set something in sql server to load blogs like filestream or is this ok?

Mike on 5/7/2010
aman - you should be able to load images using this example as well. Salvatore - No u don't.

Hansjörg on 5/10/2010
Just what i needed!

joe on 5/11/2010
Great work! Thank you. Very clear and helpful. Much appreciated.

Monna on 5/17/2010
Loved it!

Joe McCarthy on 6/22/2010
great information and well presented

shankar on 6/23/2010
Any one can learn ssis using this.It is a very good explanation

Jed Perlowin on 8/7/2010
Thank you! I needed to load pictures from a directory into a SQL table and this video told me how to do it! I used: INSERT INTO Pictures (fname, [file]) SELECT 'PictureName.jpg', * FROM OPENROWSET(BULK N'C:\Pictures\PictureName.jpg', SINGLE_BLOB) rs instead of using a staging table. I found this code on the web too!

bob huff on 10/25/2010
Great!!! Been looking for a clear, concise example for a long, long, time...

Jason Vollaire on 2/22/2011
Clear and concise, makes learning a pleasure.

sivarunsri on 2/22/2011
Very Good Tech Presentation, and More importantly Very usefull one!! Thanks Srinivas V M

faizan on 2/22/2011
very Good! presentation, it really help me. Thanks

Charlie Bruno on 2/22/2011
Very nice presentation. However, I did not see the connection to the "doc" files sitting in the folder on the hard drive in the Import Column transform. I may have missed where the reference was to the file was, but I do not recall.

robert on 2/22/2011
Needed that tip...thanks

Paul Sprunger on 2/22/2011
Thanks! Great job.

Don Weigend on 2/22/2011
The Import Column transform was very interesting, thank you for the tip.

Bryant Byrd on 2/22/2011
I've been working with SSIS for over four years and never noticed the Import Column transform. Thank you!

David Burnett on 2/22/2011
try to sync voice over better with screen activity.

Jack Hellmuth on 2/22/2011
Pretty fast. I kind of lost you when you used the column ID of 53. Where did that come from?

Dexter Jones on 2/22/2011
Enough detail to be useful. Nice job, as always.

George Squillace on 2/22/2011
How would one know the lineage ID was 53?

Maurice Ivory on 2/22/2011
It was okay

Michael Irwin on 2/22/2011
Brians videos are always good - and he always has something unexpected to convey! Thanks!

Charles Prawin on 2/23/2011
nice

Michael on 2/23/2011
VERY enlightening.

Paul Giry on 2/24/2011
couldn't see the example query put in the expression ???????

38476147DB on 2/25/2011
His speech is very difficult to follow. He needs to talk more slowly. His mouse actions need to mirror what he is talking about and slow down.

Anil Babu on 2/26/2011
really good example

Dan on 3/4/2011
Great Vid!

junks on 3/19/2011
Thanks for the concise, to the point info. Great work!

aleprex on 3/20/2011
to fast presentation!

ravi on 3/26/2011
nice

ravi on 4/29/2011
excellent

erick on 7/23/2011
need more practice, this is great

Rodney on 9/12/2011
Very good Brian.

Brett Spencer on 12/26/2011
Clearer, slower speech would be appreciated.

dip on 4/8/2012
Really Nice article to understand import column transformation.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

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