admin posted on January 31, 2010 09:50
Wiring-up to Excel can be a pain. This might help. Here's a screencast that might assist you in connecting to Excel in Microsoft SQL Server Integration Services.  Give it a try next time you have to go to an Excel data source.   Lee   ---------------------------- His name is Jas... [More]

Posted in: SQL Server 2008 , Video , SSIS  Tags:
Lee posted on January 23, 2010 08:20
I was looking around the other day on Google! and elsewhere for info on SSIS transactions and MSDTC setup, but didn’t find much; actually what I found were a lot of questions around their use. Check out my screencast as I geek with them, and try to make heads or tails out of their use. Expand ... [More]

Posted in: SQL Server 2008 , SQLServerPedia , SSIS , Video  Tags:
Slick new feature to make INSERT go faster.   Check out my screencast on the minimally logging using INSERT SELECT in SQL Server 2008. Click the “Fullscreen view” button at bottom right of applet to expand the video image.  Code files, below. Lee   &... [More]

Posted in: SQL Server 2008 , Video  Tags:

by Lee Everest, M.S.

Search


Ads

Calendar

«  March 2010  »
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2010 Lee Everest's SQL Server, etc. weblog