Lee posted on March 7, 2010 07:50
A solution that seems to work. I've been dorking with SSIS and Linq the last couple of days, and it's been enjoyable.  I tried an experiment with the "ORM" tool for Linq in a blog but that didn't work as I initially expected, and certainly needs some more work.  I probably shoul... [More]

Posted in: SSIS , .Net , SQLServerPedia  Tags:
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:
Lee posted on February 23, 2010 19:34
Awesome guide for installing/configuring SSIS A good friend of mine, Matt Ross, a super-DBA, developer, expert on Windows/VMWare/AD/etc., and teaching associate at North Lake College in Irving, TX, wrote a sweet guide for installing and configuring SSIS [1], and I talked him into letting me post on... [More]

Posted in: SSIS , SQLServerPedia  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:
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]

admin posted on December 28, 2009 07:35
A nice series to check out.   Here is a cool set of SSIS best-practice articles that I found on the MSDN blog site; you might check these out if you’re looking for some tips on making SSIS run well.  I found a few things that were pretty interesting and recommend the reading. http://blo... [More]

Posted in: The Best of MSDN Blogs , SSIS  Tags:
SSIS 2005 errors...glad many go away with SSIS 2008   It’s amazing to me on just how much better, nicer running, and less clunky SQL Server Integration Services (SSIS) 2008 is over its’ SQL Server 2005 counterpart. Every time I (have to) open it up – usually because client v... [More]

Posted in: SQL Server 2005 , SSIS  Tags:
Lee posted on November 16, 2009 12:34
An easy way to add them to your system.   I’m beginning to use environment variables more and more these days for SSIS and find it a pain to have to keep opening the system properties to get to them.  An easy way to set, list, or delete them is by using a simple vb script such as... [More]

admin posted on October 28, 2009 12:54
Both versions of BIDS installed gives an error.    The new SSIS gig fully underway, and I happened upon an error that I'd never seen before, so wanted to write it down.  You might get the following when developing SSIS and calling .dtsx files from DTEXEC locally:  Description... [More]

Posted in: SQL Server 2008 , SSIS  Tags:
Lee posted on September 18, 2009 06:14
  Very handy when you have lots of connections.  I’ve been meaning to post this one, so finally got to it…In order to troubleshoot design-time validation issues, a nice feature of BIDS is the Properties>>Execution>>DelayValidation property of SSIS.  This i... [More]

Lee posted on September 5, 2009 07:57
Someone searched my site for this…here’s the answerString literals are supported in SSIS expressions. You can find those here.  So the question was, how can I put a quotation mark in my literal string in an SSIS expression?  The answer is to use \”  in your expression.  A quick e... [More]

A straightforward look at the PIVOT Data Flow transformation   PIVOT and UNPIVOT are relational operators in SQL Server for, essentially, reshaping the way the data resides in a table.  Here, we look at PIVOT, but do so using the SQL Server Integration Services (SSIS) PIVOT Data ... [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