You might get the following error when using an OLE DB source in SSIS while trying to map a parameter in your SQL query: Error at Data Flow Task [OLE DB Source [69]]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occured. Error Code: 0x900004005. An OLE DB record is available.&#... [More]

Posted in: SSIS  Tags:
Dimitri Furman with Microsoft comes up with some pretty slick stuff, and this one is worth the read.  The post goes back to April of this year...doesn't it seem kind of slow to you lately regarding news in the SQL Server world? Besides Buck Woody posting blogs, I don't really see much happening... [More]

I published a blog posting a couple of weeks ago entitled “Geeking with Idera’s SQL Virtual database” because someone at work wanted to know if they could pluck objects out of a SQL Server backup; Idera makes some really great products and they were the first people that I turned to for a solution t... [More]

I had another great question by my buddy and super-stealth, ninja, beast-mode, middle-tier, middle-layer, business objects, BLL, DAL, patterns dude, badass programmer friend Craig Boland the other day, and this one I’m afraid I can’t answer. Craig is a super-smart consultant with Sogeti – a c# guy –... [More]

Posted in: TSQL  Tags:
Someone at the North Texas SQL Server Users's Group - NTSSUG - this past Thursday asked whether or not you could 1) map data as was being done in the Entity Framework presentation, sort of ORM/type style, and 2) somehow use the .Net 4.0 framework in SQL Server 2008 R2 SSIS.  I tried to answer b... [More]

Posted in: SQL Server 2008/R2 , SSIS  Tags:
Lee posted on July 15, 2010 12:17
Recently I met with a couple of guys from Microsoft over lunch to discuss what it might take to be considered for the award of Microsoft SQL Server MVP, and I thought that I would share this information for those interested while it is fresh on my mind. After doing some research on the program I hav... [More]

In SSIS, if you are connecting to the AS/400 when querying a table from a library you might get the following error: "The OdbcParameterCollection only accepts non-null OdbcParameter type objects, not SqlParameter objects." Possible failure reasons: Problems with the query, "ResultSet" property no... [More]

Posted in:   Tags:
Start reading here, please If you happen to have caught any of my blogs before, I like to test (and challenge) SQL Server’s “sacred cows”;  I have always written code in a number of ways to see what particular design works for a given implementation.  I’ve concluded a long time ago that t... [More]

Lee posted on July 11, 2010 19:35
There is some cool training on Master Data Services out on the msdev site that I recommend for learning the new feature found in SQL Server 2008 R2.  I actually thought that this training was something that only partners could get to, but I was mistaken; it looks like all of the content is open... [More]

Posted in: SQL Server 2008/R2 , SQL Administration  Tags:
I haven't had to call a web service from an SSIS package, but did call a package from a web service once that I blogged about, and today ran across a cool blog that outlines this. Pretty slick!  This one is nice because he shows the subtleties of calling a particular type of web service, one th... [More]

Posted in: SQL Server 2008/R2 , .Net  Tags:
You might get the following error when trying to "Enroll instances of SQL Server with a UCP." Result The version level of the specified instance of SQL Server must be compatible with the version of the UCP. Validation failed. Enrollment is not supported for SQL Server version 10.0.2531. ... [More]

Posted in: SQL Server 2008/R2 , SQL Administration  Tags:
Lee posted on July 3, 2010 18:42
A buddy this week (or last I can't remember hell I've been so busy lately) asked me if he could pluck out stored procedures, data, etc. from backups. I told him that SQL Server natively could not but I thought that there were third-party tools to do this. Remember that this is a tricky proposition; ... [More]

Lee posted on July 3, 2010 11:01
Here's a slick procedure that someone wrote for comparing two tables, pretty handy!  If you don't want to fire up your favorite SQL compare tool or table diff utility, use this script to find the differences in data that you are looking for. He goes ahead and wraps a generic version in a proc s... [More]

Posted in: The Best of MSDN Blogs  Tags:
Note: This is an "Op-Ed".  I get to do these because this is my blog ;)  If you are not interested in opinion, then this blurb is not for you.  As always, thanks for stopping by. I appreciate you! Michael Otey’s article from the June 2010 SQL Server Magazine entitled “S... [More]

Posted in: Etc. (Off-topic) , SQL Server 2008/R2  Tags:
Lee posted on June 26, 2010 10:49
I usually don't blog about the company that I work for, but wanted to mention that Capgemini/Sogeti this week was awarded something very special - the Microsoft Global Enterprise Partner of the year award.  Niiiiice!  Check out the links below for the news release and the award at the Micr... [More]

Posted in:   Tags:
I thought that you would enjoy this genius of a posting that I saw the other day...greatness!  Make sure and stop at step #8 and then go try to figure out why he got the results that he did. After reading, you'll agree that 1=2.  Enjoy!!! Lee   ----------------------- "Educ... [More]

Posted in: Etc. (Off-topic)  Tags:
You might get the following error when you run an SSIS package: Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:28:07 PM Error: 2010-06-24 15:28:08.20 Code: 0xC0011007 So... [More]

Posted in: SSIS  Tags:

by Lee Everest, M.S.

Search


Ads

Calendar

«  July 2010  »
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678
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