admin posted on March 6, 2010 08:17
Introduction Last August I looked to add the LINQ library to a SQL Server Integration Services (SSIS) Script Task. Why? Two reasons: First, because if you’ve looked any LINQ, the features of it, the language, and most importantly why it exists, you know that it is the bomb for allowing you to do... [More]

Posted in: SQL Server 2008 , SSIS , SQLServerPedia  Tags:
Lee posted on February 24, 2010 10:25
Moving packages just got easy. I worked on a large project last year at a global company that sells household items, and one thing that I liked about the project was the fact that they used ‘relative’ paths for their SSIS packages when referencing resources, such as text files, executables, xml fil... [More]

Posted in: SQL Server 2008 , SSIS , SQLServerPedia  Tags:
admin posted on February 19, 2010 04:06
Doesn't appear to be fixed! I thought that in SQL Server 2008 sp1, the ORDER BY bug was fixed, but it isn't. We ran into it yesterday.  http://support.microsoft.com/kb/926292.  Scanning the sp1 fix list, apparently this one wasn't added to it: http://support.microsoft.com/kb/968369. ... [More]

Posted in: SQL Server 2008  Tags:
admin posted on February 14, 2010 03:59
Introduction The Script Component in SQL Server Integration Services (SSIS) seems to be a somewhat inauspicious data flow task that is oftentimes avoided or misunderstood by some. When you open the task, you don’t see much - a few methods, a couple of references, and that’s about it. Truth be told,... [More]

Posted in: SQL Server 2008 , SSIS , SQLServerPedia  Tags:
Lee posted on February 8, 2010 16:40
This is what you do when you're bored. I saw a post on www.social.msdn.com about Excel data sources and SQL Server Integration Services (SSIS) that was answered by two folks, and not particularly correct by either one I might add. Someone asked a two-part question - the first was… “How... [More]

Posted in: SQL Server 2008 , SSIS  Tags:
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:
Interesting question about parameters. My good friend and super-stealth ninja middle-tier, business objects, BLL, DAL, bad*ss programmer Craig Boland asked me a question the other day about an oddity with stored procedures and functions. Eh, whassat you say? What’s a super-stealth ninja middle-tier... [More]

Lee posted on January 26, 2010 10:39
SQL Server 2008 R2 goodies are starting to rolling out. I was just looking around this weekend and noted all of the SQL Server 2008 Webcasts, virtual labs, etc. that have come out over the past few months; today I saw a post on the MSDN Blogs about some just coming out this week in fact, where... [More]

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:
Lee posted on January 19, 2010 19:58
Understanding checkpoint files In the last blog on checkpoint files, I was dorking with and investigating their contents, looking to answer the question of whether or not variables were persisted within the process.  You would think they would; after all, if a task craps out, and the next task... [More]

Posted in: SQL Server 2008 , SSIS  Tags:
Just noticed that Bigint has been fixed in SSIS 2008 I mentioned the other day that I am in the beating as it is of a project with SSIS 2005.  Funny that about the time I blogged, a friend who I worked with on a large project put in his MSN messenger sigline..."SSIS 2005 can be described as ... [More]

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:
Lee posted on December 24, 2009 09:51
These vids are really great!  The folks at SQL Share do a really nice job with their quick 2-minute videos series on SQL Server topics.  I really like the depth and breath of these short snippets, and is just right for some of the basic tasks when either doing development or ad... [More]

Lee posted on December 15, 2009 09:56
Oops. Someone forgot to include it. tablediff.exe was, from all acounts, inadvertently left out of the SQL Server 2008 install, so you’ll need to use the version from SQL Server 2005. I just checked two of my installs and couldn’t find it.  Thanks, whoever you were, for ... [More]

We have it. Might as well use it.   I found a really cool way to use the sql_variant type the other day, but ran into a problem using SQL Server and Microsoft Access. The client where I am located stores lookup data in Access, and then pushes the data from a .mdb into many client databases ... [More]

Posted in: SQL Server 2008 , TSQL  Tags:
Geeking with table variables. Again.     Table variables vs. Temporary tables. Ugh, here we go again   You often hear discussions on table variables and temporary tables in SQL Server, many of which relate to performance, which one is faster, when to use either based on t... [More]

Someone jumped the gun again. If you try to install the VS 2008 GDR R2 download and you receive this...  You probably need to get another operating system, preferrably an old one.  This is the download for VS that provides support for SQL Server 2008, as well as Team Edition f... [More]

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