Ok I found these two books
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764589237.html
and this one
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584332.html
Could someone explain the difference between these 2 books besides the fact that one is geared towards the express edition. The SQL Programming book sounds more thorough than the Express Edition book.
Has anyone worked through the Execute SQL Task example on page 148 of the WROX book? I am getting the following error message:
Executing the query "EXEC usp_GetConfigParamValue 'MYAPP', 'MYPARM', 'STRING', @MYVALUE OUTPUT" failed with the following error: "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 ("@MyValue"): Data type 0xE7 has an invalid data length or metadata length.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
The Data Flow task works fine. I tested the stored procedure in SSMS and it works fine.
I dropped and recreated the SQL Execute Task twice, being very carful to follow instructions. The Myfile variable is a string and is correctly mapped to MyValue in the SQL Execute Task. I'm at a loss. Can't get it to work.
any all-rounder good book on SQL Server
View 1 Replies View RelatedI would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.
View 1 Replies View RelatedI would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.
View 1 Replies View RelatedHi,
I have to buy two books for the MIS dept for sql server 2000. Which one do you recommend? We are still on sql 7.0 and migrating to 2000 soon. All developers have good experience with sql server 7.0.
Want something that gives you recommendation about better practices for performance issues for writing SPs.
I read all the reviews on amazon and b&N . It's confusing to choose only two.
Any recommendations?
Can Anyone tell where I can found a tutorial about Transact-SQL ?
Thanks
Hello, I wish SQL' Books.
Anyone help me..
Bye :rolleyes:
hipls tell the site's where i can download free e-books,bye,s.premkumar
View 1 Replies View RelatedHi , i am new to certifications in general..
I would like to do the certification exam 70-431. However i want to study on my own instead of going to classes.
what if i get the microsoft e-learning books or microsoft press books? will this be enough in helpnig me with the course requirements?
what are the difference between the two e-learning and MS Press books?
Hi,
I just started at a client's site and have found that the Books On Line has been removed (all other items are there in the program group instead of BOL). Is there a site at microsoft that mimicks BOL? (sybase has a 'sybooks on the web' which mimicks their 'Sybooks' product documentation.
Any help would be appreciated.
jim
Hi
I am looking for books on SQL 7.0 Administration. I would appreciate if any body could recomend.
regards
rajeev
Can anyone recommend books on SQL Server 7.0 Data Transformation Services?
Looking to find info on importing data from a Sybase server to SQL server (need good examples). Thanks.
Does anyone know of any good books on DTS? I am currently using SQL 7.
Thanks in advance
Hi there,
Any good books to Know the internals of MS-SQL server 6.5
Thanks
Vivek
How do you use BOL? I've heard time again that there is much info in BOL but when i look at it it seems too brief and not detailed. I find it hard to find what i'm looking for anyway. How do you use it?
Thanks!
naresh writes "I would like to learn sql server 2000 and I do not have any programming experienc at all so how do i learn this programme. Do you have any suggestion or any basic books or materials you guys can refer to me
Thank you"
hi guys,
i m a newbee in SQL. i wanted to know which is the nice book to start with? anyone got ebooks of SQL2005?
we are trying to build warehouse in our company its very small database but still.
we have come to a point where we are able to pull reports from the database that we have created as OLTP which is truncated and reloading everyday .
Now we have to stop doing that and just update the database and check for the changes in the existing data.
Can anyone suggest ETL book/webcast/weblinks that could help me.
Thanks in advance
Srini
I would be teaching an applied database course to buisness majorundergrads. I'm looking for a book that introduces database conceptsusing SQLServer as the database. I would really appreciate if you couldrecommend me a few such books.ThanksNemo
View 4 Replies View RelatedHi,
I am new to SSIS and wondered if there are any books around to learn in depth regarding SSIS and exampls for transformation to try and help me understand it better.
If anybody knows any guide, please let me know
Aash.
Hi,
Please give the Microsoft suggested book material list for learning SSIS
Thanks & Regards
S.Nagarajan
Can somebody recoommend me books for sql server 2005. I am interested specially in CLR inside sql and Business Intelligence.
View 4 Replies View Related
Hello,
maybe anyone knows good books or articles about ETL, ETL processes, ETL optimization ?
If you know where i can download - post a link
Thanks
Hi All -
I have come across the need to use a cube in AS 2005 for an application. Unfortunately this will be the first time writting an ASP.Net application which uses one. I was wondering if any of you had any good books or references that I could look at to get an idea of how I should approach this issue.
Thanks in advance.
Can anybody suggest a couple of good books to use to prepare for the SQL Data Warehousing exam (70-019)? I'm starting to get ready for that exam to complete my MCDBA and was wondering if anybody had any good recommendations or those to stay away from.
Thanks for any help that you can provide in this matter.
Tom
Sorry if this has been posted before, but I performed a search on the archives and didn't find anything !
I have just been turned over a SQL 6.5 SP3 / NT 4.0 SP3 server that has several SQL errors in the event log. I need to find a good book to read/scan, so I can get up to speed on SQL.
Thanks,
Mike Givens MCSE
mikeg@iowa.com
Hi All...
Can anyone guide me to a place where I can download some Tutorials / Books (Not that new) covering Microsoft SQL 2000 essentials ? I tried to find here, but artices are too advanced for me.. I need something that covers the Basic and that could be used as a small reference/guide while I am learing...
Thanks to ALL
I have a couple of years of light experience with SQL server. I'd like to start studying to take the SQL 2000 exams. I have a good test environment set up and I'm reading through the Books Online. Can anyone recommend a book or books that might be helpful for me? My end goal here is to pass the test in the near future, but I want to really learn SQL rather than just learn to pass the test.
Thanks,
Allie
Dear all
Where can I download Sql Server Books Online for any versions of 6.5 or 6.0 or 4.
thanks
Hi,
Can anyone suggest good books on exclusively sql server development..Not for the beginners but at intermediate to advanced level.. Books which gives good understanding on Stored Procedures, Triggers, Cursors, Functions...
Hi all
i am beginner with sql server 2005
and i need good books for good beginning
i found many books but i dont know which book i chose ...
what is the books you advice me to read for stability begnning ??
thank you
Can anyone make some good book recommendations for SQLServer2000 other than the Microsoft BOL?
Thanks