Hello,
I know the basics of DTSs and have been using them for a while. Now I REALLY want to learn the advanced concepts related to DTS's e.g.
How to make use of the "Inner Package Global Variables" Tab (which is visible in the DTS Designer "window")
How to make use of the "Outer Package Global Variables" Tab (which is visible in the DTS Designer "window")
How to make use of the "Outer Package Global Variables" Tab (which is visible in the menu bar option #4 Designer "window")
Many advance thanks for your help.I know the basics of DTSs and have been using them for a while. Now I REALLY want to learn the advanced concepts related to DTS's
I can think of much better uses for your time. DTS was a klunky tool to begin with, poorly implemented and poorly integrated into the SQL Server environment. I would never have recommended that anybody use it for anything beyond simple data transfers, and now that it has been completely dropped from the latest SQL Server version 2005 it might be more useful for you to study Latin.|||Hmmm... Thanks for the feedback.
At the moment I don't think my college will be shifting to SQL 2005 and that is why I thought that I'd get better on it. However you have given me some useful food for thought by saying that SQL 2005 doesn't offer DTS's at all.|||I can think of much better uses for your time. DTS was a klunky tool to begin with, poorly implemented and poorly integrated into the SQL Server environment. I would never have recommended that anybody use it for anything beyond simple data transfers, and now that it has been completely dropped from the latest SQL Server version 2005 it might be more useful for you to study Latin.
Dammit man! Every time I feel smart, you tell me I've been doing it all wrong. Now I'm going to rewrite some huge processes. I hope we don't migrate to 2005 anytime soon.|||SQL Server 2005 dropped the DTS utility, and it has been replaced by something called Integration Services which is an even bigger monstrosity.
The two utilities have the same concept, but they are sufficiently different that in-depth knowledge of DTS packages is not going to help you with Integration Services.|||Will I still be able to execute ActiveX scripts?|||Amo, Amas, Amat, Amamus, Amatis, Amant...|||Hey, isn't that basically the Barney song in Latin?
("I love you, you love me...")
What's that have to do with ActiveX and DTS?|||yes, you can executed Active-X script, in more than one way in SSIS. You certainly can do it, and for getting DTS packages running quickly, it is really convenient... When you try to do "heavy lifting" with Active-X in SSIS, you'll be reminded very quickly just how many better choices SSIS offers!
Push for the conversion to SQL 2005. Push hard!
-PatP
Showing posts with label basics. Show all posts
Showing posts with label basics. Show all posts
Monday, March 19, 2012
advanced SQL tutorials
Dear All,
Can you suggest a good book or set of websites which have advanced SQL tutorials for SQL server? Got the basics but looking to build on my knowledge.
...cause knowledge is power...Here are some books
http://www.sqlteam.com/store.asp
And read every post here, and over at sql team.
Use Books online to try and figure out a posters question in Query Analyzer. Most often than not you will see someone answer the question.
Good Luck|||You might want to be a bit more specific. SQL Server has components that cover a broad range of topics. Are you a developer seeking to increase your knowledge of T-SQL and ADO? Are you a DBA seeking the best practices for securing your data and performance tuning? Are you a business analyst looking to learn MDX and OLAP?
Lots of sites to browse. Google is your friend.
Regards,
hmscott|||You might want to be a bit more specific. SQL Server has components that cover a broad range of topics. Are you a developer seeking to increase your knowledge of T-SQL and ADO? Are you a DBA seeking the best practices for securing your data and performance tuning? Are you a business analyst looking to learn MDX and OLAP?
Lots of sites to browse. Google is your friend.
Regards,
hmscott
Sorry for late reply and thanks for recomendations! Yes trying to learn more about complex queries with t-sql and db design and implementation for real life apps, had DB modules at Uni but it seems like hardly anything compared to the problems I face now in my job!
Can you suggest a good book or set of websites which have advanced SQL tutorials for SQL server? Got the basics but looking to build on my knowledge.
...cause knowledge is power...Here are some books
http://www.sqlteam.com/store.asp
And read every post here, and over at sql team.
Use Books online to try and figure out a posters question in Query Analyzer. Most often than not you will see someone answer the question.
Good Luck|||You might want to be a bit more specific. SQL Server has components that cover a broad range of topics. Are you a developer seeking to increase your knowledge of T-SQL and ADO? Are you a DBA seeking the best practices for securing your data and performance tuning? Are you a business analyst looking to learn MDX and OLAP?
Lots of sites to browse. Google is your friend.
Regards,
hmscott|||You might want to be a bit more specific. SQL Server has components that cover a broad range of topics. Are you a developer seeking to increase your knowledge of T-SQL and ADO? Are you a DBA seeking the best practices for securing your data and performance tuning? Are you a business analyst looking to learn MDX and OLAP?
Lots of sites to browse. Google is your friend.
Regards,
hmscott
Sorry for late reply and thanks for recomendations! Yes trying to learn more about complex queries with t-sql and db design and implementation for real life apps, had DB modules at Uni but it seems like hardly anything compared to the problems I face now in my job!
Subscribe to:
Posts (Atom)