SSIS Requirements
Jun 6, 2007
I have seen it mentioned that, unlike with the MSDE where DTS runtime was covered, the new SSIS is not covered by the SQL Server 2005 Express.
Does anybody know of an official microsoft web page detailing comprehensively what is required.
As far as I can gather the client will need a full version of SQL Server 2005, enabling the installation of the client tools, which as far as I can tell are required for the running of the SSIS.
This statement could be totally wrong but clear information seems hard to come by and seems mainly hearsay.
Thanks
View 11 Replies
ADVERTISEMENT
Apr 17, 2008
Hey guys I have a simple SSIS package up and running locally i.e i have Visual Studio 2005 and SQL Server 2005 installed.
Now If i wish to deply this SSIS package to a new server what do i require to be installed on the new server.
I.e SQL server 2005 will be there but will i also need Visual Studio 2005 to be installed ?
Also to actually run the package do i only need the .sln file
View 8 Replies
View Related
Jul 20, 2006
Is it necessary to have SSIS installed on the Server (SQL Server) in order to run SSIS programs? Or is SSIS just a client-side, developer tool that can create and test programs against various remote data sources (SQL, Oracle, flat files, etc.)?
What must be installed on the server in order to run SSIS programs?
View 1 Replies
View Related
Mar 29, 2006
Can someone tell me what are the security watchouts there are in running SSIS or the SQL Server Agent? I am having trouble running a job on a package that runs fine through Integration Services. The only difference seems to be that SQL Server Agent is running the job on the schedule.
Does SQL Server Agent need to have certain rights?
Do I need to be part of a certain group besides Admin?
Does the package need to have a particular security for someone to run the job?
I was finally able to get the package set but now I can't schedule the thing to work.
View 1 Replies
View Related
Dec 21, 2007
Hi,
I have a VB.NET program which creates a Job (Microsoft.SqlServer.Management.Smo.Agent.Job) and schedules it, to load and run a existing SSIS package, which is on a different server.
I'm using the following assemblies for this purpose.
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SqlEnum.dll
To make this application run in my application server, do i have to install any SQL server components or SSIS rumtime components? Or Is it enough if i copy only the above mentioned dlls to my applications bin directory, in my application?
Note: I have the enterprise edition of SQL Server 2005 installed on my database server.
Thanks in advance.
Karthik
View 4 Replies
View Related
Jul 20, 2004
This is taken directly from a job requirement (names are not mentioned to protect the ignorent...I meant Innocent): The employee must occasionally lift and/or move up to 25 pounds. While performing the duties of this job, the employee is frequently required to stand; walk; sit; talk or hear; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl.
View 6 Replies
View Related
Sep 6, 2006
I am considering buying a new home PC but want to make sure it can handle SQL 2005. Most of what Im looking at comes with XP Home edition. I found this:
http://www.microsoft.com/sql/editions/developer/sysreqs.mspx
but it doesnt specifically say Home edition, and I dont want to purchase without knowing this first. Does anyone know a link that would specify this?
TIA, cfr
View 2 Replies
View Related
Aug 30, 2005
saravanan writes "hi,
At present i am a B.E. i am quite intrested in sql servers.
i want to be a full fleged DBA. so please guide me , what are the basic requirements and necessary exams to be given for the same and become a DBA in a minimum required time?"
View 2 Replies
View Related
Jun 17, 2005
For SQL 2000, what are the licensing requirements for a clustered environment? I thought you needed datacenter for the OS, is there a clustered version of sql server, or do you need 2 copies of enterprise edition. Also, if you cluster can you license sql cals for clients, or do you have to do by processor?
View 4 Replies
View Related
Apr 16, 2007
I have a sql server (2k sp4), a web server and a development machine.
I need to install sql server reporting services and am confused as to the prerequisites and as to what gets installed where.
Is there a server install and a client install or do I run the same install on both (and deselect what's not required on each).
Sorry it's a bit vague but in my research various people have told me various different things.
View 3 Replies
View Related
Nov 24, 2004
Hey all,
I couldn't find an answer anywhere on the site, if there is one, could you please let me know where to go? Thanks.
Here goes. We receive large csv files, around a million records a month. What we need to do is:
- Of course, import these records
- Be able to run failry heavy reports on around 3 months worth of data (about 3 million records)
- Wanting to store at least a years worth of data
What I need to know:
- What server(s) spec (CPU, HDD, memory, etc) would we need to import and run reports quite fast. Don't want the reports/imports to take days to run. The reports will need to be run by about 3-5 people at the same time
- What OS and database type should I use (I was looking at Windows/Linux and MS SQL/MySQL)
- If we run these types of reports, can we use the same SQL server to run/store other applications (eg. CRM, etc) with no real impact on performance. There would be at least 20 people using the CRM database at the same time.
Thanks
View 4 Replies
View Related
Jun 14, 2006
Can 2005 be installed on XP Media Center Edition? I looked on the SQL site,
but it only references Windows XP, not this particular version. Any whitepapers, links, etc., would be especially appreciated.
TIA, ChrisR
View 1 Replies
View Related
May 9, 2008
What are the minimum requirements for setting up replication ?
i mean, the connection requirements, bandwidth requirements, minimum hardware and software requirements ?
Is it possible to setup a replication across the internet ?
View 2 Replies
View Related
Oct 4, 2007
What security settings are needed to allow users to veiw reports using SQL Server 2005 Reporting Services Web interface. We have tried adding users to Active Directory Groups and adding these groups to: the security of the folder containing the reports in Reporting Services and the security of the individual reports in Reporting Services. What am I missing? Does something need to be set when creating the report itself?
View 6 Replies
View Related
Oct 19, 2007
Hello experts out there,
Just one quick question, will installing reporting services require the server to reboot or sql to restart? I'll do this to a production server and just wonder if I can do while the box is in use.
Thank you in advance. You guys rock!
View 2 Replies
View Related
Feb 13, 2007
I recently was moved into an applications developers position here at the lawfirm I work at.
Thusfar, its been alot of straight ASP, SQL2000, and Access.
I know the need for me to know .Net is coming, and Ive decided to start playing with ASP.net so I can look a bit proactive..
Ive looked over what I need to get started, in liu of Visual Studio I know of the VS Express options. However, I currently have SQL Server 2000 installed locally on my machine along with IIS 5.1. All the VS Express information Ive found keeps referencing SQL2005 express. Can I get away with using what I already have with 2000? Or if not, can SQL2005 express be run alongside with SQL2000?
Any assistance would be greatly appreciated.
Brian
View 2 Replies
View Related
Feb 23, 2008
hello,
What are the requirements to install sqlserver2005 in my pc.I am using windows xp sp2 in my pc.
One of my friend said, windows server2003 is compulsory(to get data base functionality in sqlserver 2005 and other features) in local pc .Is it correct?
And i am not getting database features in xp sp2.
Can any one help me?
View 2 Replies
View Related
Nov 6, 2001
Anyone know where to find some hardware requirements based on database size? Thanks!
peter
View 2 Replies
View Related
Nov 21, 2000
Hello!
Does anyone know where can i find an information about hardware requirements for SQL-Server 2000. I mean information of different kind of cases (amount of users and transactions etc).
thanks!
Juise K.
View 1 Replies
View Related
Jan 17, 2003
I had some issues yesterday with the fact that some of the tables I had indexed views for did not have a unique/clustered index. The tables had unique indexes and clustered indexes but not a unique/clustered index. What I was seeing were rows that should have been in the view, not showing up in a regular select but they would showup in a with noexpand hint.
To fix the problem I created a unique/clustered index on each of the underlying table but cannot find that requirement anywhere, is this a requirement and if so can someone tell me where to find it.
Thanks
View 2 Replies
View Related
Nov 6, 2007
Hi ,
I want to install a new SQL 2005 server. i looked on MSDN, it says to create one or more domain user accounts. That means to create a windows domain. Is it neccessary? All I want is a stand-alone SQL server. right now we are working with SQL 2000 and we want to build a new server with SQL 2005.
Please send me a short feedback.
View 6 Replies
View Related
Jul 20, 2005
We have a win2003 server box that is using MS-SQL 2000. We have a 20user license on this server at the present time. We have a need toallow up to 5 simultaneous additional users access to a subset of thisdata from our IIS server. How does this affect my current SQL ServerLicense? We can restrict access via connection pooling, etc. Can weuse a 30 user license or must we go to a CPU license? Does anyoneknow where to find Microsoft licensing information on this?
View 1 Replies
View Related
Jul 27, 2006
Could any one pls Explain about the Four-Part Name Requirement for OLE DB Provider.
Thanks
-Sivaraman Latchapathi
View 4 Replies
View Related
Apr 10, 2006
We€™re doing a website for a TV station, and they want to have a live TV broadcast on their website, our experience is basically in CMS and portal solutions, but we never had any experience in live streaming, so this is all new to us, so we€™re looking for a technical and financial proposal with your suggestions and recommendations, this is the details of the project with some of the inquiries we have:
-The signal is SDI (Pal 25 fps)
-The output (online streaming) 15 fps
-The user will have two options to view the movie in:
1. Low: 56K
2. High: 300K
-The video should come within a customized designed page, probably as a code we can place inside an html table€™s cell, not as a link for external link
-We€™re expecting about 200 users for the video each month; each user€™s logon time expected 10 min.
-We have a Red hat Linux on our server that will host the site, and we use php/MySql technology.
Inquires:
1. Why Windows media is better then Real in terms of performance, can you provide us with a comparison table to include it to our client?
2. If we choose Windows media, what are the requirements we need to have, form both; the TV station side, and in our Linux server? And how much would it cost?
4. Is there any hardware required from the TV station side such as DVR, or some sort of encoder, if so; what€™s you€™re recommendations (type/ brand), please note that this is a TV station and it needs a high quality professional hardware
5. How (and this is probably the most ambiguous task)
5.1. Do you broadcast the digital signal coming from the encoder (I guess) to the server?
5.2. And then place this signal on a PHP page? Do you give us a link to embed in our code?
6. If we choose to host the live streaming on a separated server and include the URL in our code, would that still required from our server to support Windows media, or it doesn€™t matter as long as the video streaming is hosted on a Windows streaming server
7. How much disk space does it need to host a live streaming (with the details mentioned above)?
We would really appreciate your comments and suggestions, as this is our 1st time to dealing with live streaming.
View 3 Replies
View Related
Dec 15, 2006
Hi all. First, please accept my apologies for any obvious questions, as im very new to this!Anyway, 2 small questions:
I dont have the 'server running' icon in the system tray... The little grey box with a green arrow. have i installed SQL incorrectly?
This leads my to my other question:- After installation (which, i think went fine), i learnt that SQL Server Express cannot run with more than 1 CPU. But i have a Duel-Core. Would this cause problems?
Again, sorry if if missed any previous posts on this.
Thanks
Adrian.
View 1 Replies
View Related
Feb 19, 2008
I have been advised to design multidimensional model based on the operation data model.
What I have is ----
Couple of documents about the application.
Data model of operational data.
Now I have been told to create a datawarehouse from which any type of wuestion can be answered.
This seems horrendous.
Please guide.
View 5 Replies
View Related
Dec 26, 2006
We need to create a SQL server login that should not be having permissions to do any changes (CREATE/ALTER/DROP) on database objects like (Tables, views).But should be able to (CREATE/ALTER/DROP) stored procedures. Also using this login they should not be able to (CREATE/ALTER/DROP) databases.
Please let me if this is feasible in SQL Server 2005.
View 6 Replies
View Related
Oct 30, 2000
I'm developing a website that will be suported by a SQL Server database. The estimated number of records for that database will be around one million. I'm concerned with the possibility of my machine being unable to respond to the needs of such a database so i decided to acquire a new one. How do i calculate the hard disk and RAM i'm going to need for this database to function properly ? I know that i can make a HD prediction by adding the sizes of each field of my database and multiplying by one million but i don't know how much KBs each field occupy (some of them -few- will even be free text fields). And the RAM ?
Help... Anybody ?
Thanks,
Carlos.
View 1 Replies
View Related
Mar 30, 1999
Hello
I am trying to upgrade our 6.5 server (which approx takes up 18GIG of data/log) to 7.0...it failed since I only have 7GIG space left.
Do I realy need to come up with an additional 18GIG to accomodate the upgrade?
Thanks. Bob
View 1 Replies
View Related
Oct 7, 2013
Does this look correct for MERGE SYNTAX?I want to INSERT INTO the target table,new service contracts sold with the start date,from historical table by month, only if they don't exist in the target table, doing nothing if matched. . . but the source table is indexed Fiscal Period descending and I have multiple renewal versions of the same contract number in following years. . .
MERGE dbo.SERVICE_CONTRACTS_NEW AS Target
USING (SELECT r.Customer_Acct, r.[Contract], r.Start_Period FROM dbo.ACTIVE CONTRACTS r ORDER BY r.FiscalPeriod ASC) AS Source
ON Target.Account_Nbr = Source.Customer_Acct AND Target.[Contract] = Source.[Contract]
WHEN NOT MATCHED BY TARGET
THEN INSERT (Account_Nbr, [Contract], FiscalPeriod_Start)
VALUES (
Source.Customer_Acct
,Source.[Contract]
,Source.Start_YYYYMM
);
View 1 Replies
View Related
Apr 17, 2007
I was trying to install the Developer Edition of 2005 last night, and ran into a strange issue. I specified F:SQLDev as the installation directory, but the installer still refused to install claiming lack of disk space. Checking the disk cost, I saw that it was still asking for about 1.5 GB on my C: drive. I double checked, and I did specify the installation directory as F:SQLDev.
Is there documentation somewhere that describes why it would require space on the boot drive? Or am I missing a switch somewhere or something?
Thanks in advance for any help.
View 2 Replies
View Related
Oct 30, 2006
I am developing a data mining solution for a client using SQL 2005.
Do they have to purchase a separate license for a replicated environment? Like a hot site....
Thanks, ]
BI Joe
View 1 Replies
View Related
May 30, 2007
Hi!
I am installing SQL Server 2005 Express as part of my setup. On Windows 2003 Servers with password policy enabled, the SQL Server 2005 Express installation fails. Here is the error I am getting - "the sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online.". If I disable the password policy, the SQL Server 2005 Express installation is OK.
Is there a parameter that I can pass to the command line to get around this?
Thanks!
View 3 Replies
View Related
