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 , 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 , 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 , .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 , 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 “SQL ... [More]

Posted in: Etc. (Off-topic) , SQL Server 2008  Tags:

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
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 2012 Lee Everest's SQL Server, etc. weblog