Hi,
I am new to SSIS.
1) I want to create a SSIS package to execute 5 stored procedures one by one. Stored procedures has parameters.
2) I want to create a SSIS package for ETL. To extract data from different tables from a database and insert into a new table in the same database on a monthly basis. How do i do these two?
Is there a good material i can go through to achieve these tasks?
Thanks in advance
does any one know any good pages to get some sql commands
and explainations thanks
Hi
I was searching some books about SQL but all that i found was "Big books", i mean, i found books about all SQL Server and i just need to know a few things.
I'll need to make queries to a DB and make excel or acces reports based on the query result.
Well, thanks in advance
Hi,
I would like to create views in TOAD 9.1 Application.
Could any one help me how to write Sql.
Below are the tables which i have created.
1) DIM_RANK_GRP:
CREATE TABLE DIM_RANK_GRP
(RANK_GRP_ID NUMBER NOT NULL,
RANK_GRP VARCHAR (20),
PARENT_RANK_GRP VARCHAR (20)
HIERARCHY_TYPE VARCHAR (20)
);
ALTER TABLE DIM_RANK_GRP
ADD PRIMARY KEY (RANK_GRP_ID)
2) DIM_PROFITABILITY:
CREATE TABLE DIM_PROFITABILITY
(
PROFIT_ID NUMBER NOT NULL,
PROFIT_VAL NUMBER,
PROFIT_DESC VARCHAR (30)
);
ALTER TABLE DIM_PROFITABILITY
ADD PRIMARY_KEY (PROFIT_ID)
3) Fact Table: Agg_Rx_Weekly_Sales:
CREATE TABLE AGG_RX_WKLY_SLS
(TERR_ID Number,PFZ_PROD_ID Number ,DT_SK Date,CHNL_ID Number,SPEC_ID Number,RANK_GRP_ID Number,PRFTY_ID Number,Nrx Float(64),Trx Float(64),
Nrx_unit Float(64),Trx_unit Float(64),Nrx_Dol Float(64),Trx_Dol Float(64),Mkt_Nrx_Unit Float(64),Mkt_Trx_Unit Float(64),Mkt_Nrx_Dol Float(64),Mkt_Trx_Dol Float(64),Mkt_Nrx Float(64),Mkt_Trx Float(64)
);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_TERR
FOREIGN KEY (“TERR_ID�)
REFERENCES “DIM_TERR� (“TERR_ID�);
ALTER TABLE�AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_PERD
FOREIGN KEY (“DT_SK�)
REFERENCES “DIM_PERD� (“DT_SK�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_SPEC
FOREIGN KEY (“SPEC_ID�)
REFERENCES “DIM_SPEC� (“SPEC_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_CHNL
FOREIGN KEY (“CHNL_ID�)
REFERENCES “DIM_CHNL� (“CHNL_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_REL_PROD_MKT
FOREIGN KEY (“PFZ_PROD_ID�)
REFERENCES “REL_PROD_MKT� (PFZ_PROD_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_RANK_GRP
FOREIGN KEY (“RANK_GRP_ID�)
REFERENCES “DIM_RANK_GRP�(RANK_GRP_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_PRFTY
FOREIGN KEY (“PRFTY_ID�)
REFERENCES “DIM_PRFTY� (PRFTY_ID�)
Advanced Thanks.
VENKAT
Hello,I'm new to SQL Server, have alot of experience with DB2 and Oracle,and have beentasked with supporting SQL Server. Could anyone suggest a goodadministrator book?Thanks!!Dave Schaeffer
View 1 Replies View Related
I am in the process of creating a user interface that will give the users a list of reports to choose from. I wanted to write an interface in ASP .NET with C# to pull information for different reports from the reporting services web service. I have successfully done this with C# Windows Form. The project requires it to be web-based.
Problem is, I am new to web forms and would like a recommendation for reference materials to help me program ASP .NET with C# and using the web service. I am still learning ASP .NET and C#, so I would like something fairly basic.
Any help is appreciated.
Has anyone used any CBT's for SQL7 or could recommend a good company for study materials. I have seen the product from CBT systems and Keystone and was not impressed.
View 2 Replies View RelatedGreetings,Can someone recommend me some online redbooks or anylink regarding "Migration from Sybase to Sql Server"?Any feedback will be appreciatedTIA
View 2 Replies View RelatedWho has SQL Server 2005 teaching material? Anyting is ok. thanks. :)
View 2 Replies View RelatedHow to use hierarchy id data type in Bill of material database.
The msdn example [URL] ....
Dear Sir/Madam
I am certified Oracle DBA/Developer/Internet Developer. Now, I am interested in Microsoft Certificated DBA (MCDBA/MCSD).
By the way, I don't want to waste money to purchase the Microsoft exam software (Self Test Software) and training material. So, I want to exchange the MCDBA exam software and training material with you by using Oracle OCP 8i, Developer 2000 Rel 2.0 and MCSE 2000 Self Test Software.
I can use Oracle 8iDBA, Oracle Developer and MCSE 2000 self test software listed below to exchange 70-228,70-229,70-215,70-216,70-175 or other MCDBA 2000 and MCSE 2000 self test software and training materials.
<Oracle 8i DBA>
1Z0-001 Introduction to Oracle: SQL and PL/SQL
1Z0-023 Oracle8i: Architecture and Administration
1Z0-024 Oracle8i: Performance Tuning
1Z0-025 Oracle8i: Backup and Recovery
1Z0-026 Oracle8i: Network Administration
<Oracle Developer>
1Z0-101 Develop PL/SQL Program Units
1Z0-121 Developer/2000: Build Forms I
1Z0-122 Developer/2000: Build Forms II
1Z0-123 Developer/2000: Build Reports
<MCSE 2000>
70-210 Installing, Configuring and Administering Microsoft Windows 2000 Professional
70-215 Installing, Configuring, and Administering Microsoft Windows 2000 Server
70-216 Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
70-217 Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure
70-219 Designing a Windows 2000 Directory Services Infrastructure - (Includes 4 Case Studies)
By the way, if you have any one of 70-228,70-229,70-175,70-176,70-100, I can use whole set of Self test software to exchange yours.
Please provide email accounts with at least 5MB space for exchanging Self Test Software.
Thanks and Regards,
Jack
OCP DBA/Developer/Internet Developer
jacklam@tom.com
I'd like to display the our range of coverage of material stocks via SSRS. The underlying database provides all the actual stocks of our materials as well as the current and planned consumption. Now, my problems are the design, as I am not sure If I can realise it with SSRS, and the way of displaying the actual range of coverage as I have no future time informations.
Has anybody made experiences with reports like that?
I have a query that returns material(items) that are used in an event on a certain day.
SELECT C.categoryName, count(I.itemID) AS InMission
from items as I
RIGHT JOIN Categories AS C on I.categoryID = C.categoryID
INNER JOIN LinkMissionItem as LM on I.itemID = LM.itemID
INNER JOIN Missions as M on LM.missionID = M.MissionID
where '2015/12/19' BETWEEN M.freightLeave and M.freightReturn AND isReturned = 0
GROUP BY C.categoryName, C.categoryID
ORDER BY C.categoryID
There are a total of 20 categories and I would like all the categories listed in the result even though there are no items booked in a mission. At the moment, I can only get the categories that have items in that category booked in a mission. I hoped that the RIGHT JOIN on the categories table would do the trick but it doesn't.
I have 2 tables each containing a material type. Table 1 contains material from their 3D application. Table 2 contains material with specific values that is not ours and we cannot rename or edit the data. I need a type of junction or mapping table that can connect the user material to the preset material. for example:
User Material = Wood-MDF
Preset Material = MDF Panel
I figured that i would make this table with 3 fields (ID, UserMaterialID, PresetMaterialID).How would i then construct a query view / Stored procedure that would return the Preset data values based on the user material id?
Hello All,
I am new to this forum as well as sql. I want to learn skills with SQL. Can anyone point me to the right direction for some free pdf's/learning notes.
Thanks in advance.
sqlnewbie.....
Hi, not sure if this is the right place to put this but as its the beginners forum I thought I'd take a chance.
What's becoming more evident to me is my weak SQL skills. I'd like some advice on the best place to learn properly. It's starting to become a part of my role and i'm struggling a bit.
Should I go on a course? I have a number of teach yourself books and an evaluation version of the software but is this enough? I've worked through the books but struggle to apply the book to the real situation i.e subqueries
How did the more proficient of you learn SQL?
I want to get to a stage where I can help others with their SQL problems rather than always being the one helped.
Any advice much appreciated.
Hello
I am considering taking an on-line course in SQL, such as...
http://www.transcender.com/product.aspx?product%5Fid=Pak%2DMCDBACORE&dept%5Fid=100403
I do not work with SQL but I do have good computer knowledge and experience of MS Access and visual basic. Would it be plausible for me to complete such a creditation without the work experience or is it asking too much? I have a lot of time to focus on it at the minute. Does anyone have any knowledge of this particular company or can you recommend a better one?
Also, is there any way I could complete this course on a Mac (pre intel)?
Any help/info will be greatly appreciated.
Thanks
I am thinking about doing a computer course.It is learning about sqlto become an MCDBA.I am trying to find out how difficult this could beas I will be doing it from home and it is going to cost over £4000 forall the CD ROM's,books etc.You understand I don't want to start thecourse only to find I can't do it.I have owned my own computer for 18months and enjoy it.If anyone with experience can reply it would beappreciated.
View 4 Replies View RelatedI started a course and got to the lab section. It asked for a password giving me the name of student. I don't know if I was given a password when subscribing for the course. Certainly no in the confirmation email.
Where did I go wrong?
John.
I have four questions about Tsql language:
1. Is it important for a web developer to learn Tsql ,if he uses Data driven sites or just learn (select ,update,insert,order by ...I mean the most popular statements) ?
2. Where to learn Tsql ,is there any free books ,videos,tutorials,articles ,websites (ofcourse sql server 2005 with it's enhanced Tsql syntax?
3. Can I use a Tsql generator tool or Builder instead of learning the language ?
4. Where I can find such a tool?
If you do not know all the answers ,tell me what you know ,I will appreciate all the answers,and plz need help from the moderators also.
Thanks
I'm used to programming in PHP and need helping learning how to do SQL stuff in VB (using Visual Studio Pro, if that makes a difference).
For instance, in PHP I might do something like this:
//some code to connect to the database
$result = mysql_query("SELECT * FROM `table_name` WHERE `some_field` = true") OR die("ERROR: ".mysql_error());
while ($row = mysql_fetch_assoc($result)) { extract($row); //do what needs to be done with the variables}
How can I do that in Visual Basic?
This is what I have so far and that's only from cutting and pasting from some websites. 1 Using connection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True")
2 connection.Open()
3 Dim command As SqlCommand = New SqlCommand("SELECT * FROM GE_Data", connection)
4 'now how do I get to the data???
5
6 connection.Close()
7 End Using
-Mathminded
Any recommendation on a book for a new DBA to learn about SQL Server 7.0 replication?
View 2 Replies View RelatedI'm looking for a book or a couple of books to learn SQL (in general aswell as various versions from different vendors). A couple of books that would take me from beginner through advanced topics. Any good suggestions?
/ ludde@freebox.com
Hi, I am new to this forum. I have a question about learning SQL. I never really had much of a reason to learn anything dealing with server programs. I now would like to learn about SQL. Is there a program that anyone knows about that can help me learn?
View 7 Replies View RelatedHi Guys,
Well, as a VB/VBA applications developer I'm not well prepared for this, but it looks like I will be riding herd on a production SQL Server.
TSQL I know well enough to get along, but where can I get a fast fix on all the logins, security, and process management info? Today we had a DTS package crash overnight and it took me forever to figure out that it had left half a dozen tables locked. (Note that the scripts for the DTS package are being re-written as we speak with use of transactions and NOLOCK.) Meanwhile tech support was handling a whole mess of grumpy users.
Are there any books you would recommend as resources/references? Is there a particular author who is good at writing the stuff you really need to know in English that can be read by a mere mortal like I? I am fond of the Microsoft resources/help files but I'd like to have somthing that holds highlighter and post-it flags a bit better. Not to mention something that focuses more on the beast as a whole rather than the minutia at length.
Thanks for any suggestions!
Hi:
I'm an aspx programer, mi database is in access.
I want to learn sql server enterprise in order to improve my aspx's and databases but I dont know where to start learning.
I have downladed a tutorial from microsoft web site but I dont know what topic learn first
SQL Server Tools
Analysis Services
Data Mining
Integration Services
Notification Services
Reporting Services
What topic I must read first? I just want make an aplication to read and update data from a database.
Do you know another good totorial on the web?
Thanks!!
Hi,I have been trying to register for E-Learning for MS-SQL2005 ... but IE aborts any time before the registration is finished ... (after sign-up, or information fill up, or before those steps): "Microsoft Internet Explorer a rencontré un problème et doit fermer. Nous vous prions de nous excuser pour le désagrément encouru.". I don't believe this working as designed despite this pb shows me that Microsoft has still progressed to make in quality ... (my computer is running W2K and is up to date with Windows Update).Any idea to access knowledge courses on internet for MS-SQL2005 are welcome :) Jean-Marc
View 4 Replies View RelatedI discovered that many of my very busy colleagues are having anextremely difficult time pulling themselves away to take vitaltraining when it requires being away for consecutive days. I justcompleted training for .NET in Chicago through a mentored learningprogram that personally helped me to tackle that same issue. Thoughthe mentored learning training allows complete interaction withclassroom version labs and interaction with an on staff expert on thetopic, it does require some discipline in that I was responsible forthe pace I was moving. The benefit for me is that I did not have tocommit myself to a set schedule of consecutive days beinginaccessible. I had the flexibility to engage in the mentoredlearning program once a week until I completed the course. Plus thementored learning lab was very comfortable and for some of mycolleagues who would are able to travel, it is near O'Hare Airport andthere is a hotel next door.Once I get more help in our data center, I do plan on spending sometime, and some of our firm's money on some instructor-led classes thatwill require me to be away for consecutive days and I can get done alot quicker. This particular training centers line-up of classes andits personnel impressed me. I thought I would alert the rest of youto this attractive alternative and would be happy to provide you thedetails on a need to know basis either through this discussion groupor you can send me an email to Join Bytes!.
View 1 Replies View RelatedHi group.I have been working with ColdFusion and SQL Server for some timenow....abour 4 years I guess. I have developed various web applicationssuccessfully. The scenario I am in is that a company would like me to comeon with them as a lead database admin type guy. I would still do a little CFdevelopment....but mostly it will be data management with SQL Server.Now....like I said...I have worked with databases for quite awhile...specifically SQL Server, and I am quite comfortable with it......butIm kinda worried that the position involves a lot more than I have done.Mind you I will have first hand knowledge of the database in place which iswhat this position is for....so I have somewhat of an advantage. But....Imjust wondering if I should do a short course that teaches me the ins andouts again. It's like I develop databases by winging it. Know what I mean. Ithink I know what I am doing...but what if I don't? Just wondering what yourthoughts are.
View 6 Replies View Relatedcould we download the videos of SQL Express learning resources as we can do it with the VWD, VB, C#????
there is another link to do it???
will they be available in a short future?
Can somebody tell me if the microsoft time series (MTS) algorithm use the unknown p approach in order to learn an ART model, cited in Autoregressive Tree Models for Time-series Analysis by Meek, Chickering and Heckerman ?
If the answer is true, what is the pmax that the MTS algorithm uses?. Is there a parameter to control this value?
If the answer is false, what approach MTS algorithm uses in order to learn the structure of a ART(p)?
Thanks for your help.
Can anyone tell me about some good online tutorials for learning stored procedures in SQL Server 2000?
Any help will be greatly appreciated.
Thank You.
Hi All,
I have Oracle 9i personal edition on my laptop which I use to learn Oracle/SQL including creating and quering tables. With this I have been able to go into jobs confident with being able to query Enterprise implementations of Oracle in a commercial environment.
Now I would like to learn Microsoft/SQL and I was wondering whether Microsoft's SQL Server 2005 Express will be enough for me to learn MS/SQL like Oracle personal edition has.
Regards,
Seaweed