Answer Questions
PeterVrenken Can We assign DataSet object to Object Type
Hi Friends, I am having a Package scope variable DS of type system.object .In the Script Component which accept this variable as ReadWrite type I am Making the following assignment. Public Overrides Sub PostExecute() Variables.DsReport = DsReport // DsReport is a Data Set Object Created and Populated inside the script Component End Sub I am getting error while doing this sort of assignment. Please help me to solve this problem Regards, Mahe Which error do you get -Tom ...Show All
Vanyel MSDB database grows too much even though its empty.
In my SQL Server 2000 msdb database I have several DTS and a few jobs. I also do backups daily. All this should make the msdb grow but I've removed most of the logs and histories and, still, the database is almost 1Gb big. The log file is almost at 0. It is the data file that ocupies the whole size. I'm thinking it must be some kind of corruption of a table so I ran dbcc checkdb, checktable, cleantable, checkalloc, dbreindex and indexdefrag. Nothing seems to work in order to make it smaller. Any ideas Thanks Hi Marcos, After you deleted all the history. You will need to shrink the data file if you want to make your database smaller in size. You can use DBCC Shrinkfile command for the above ...Show All
ooh_flirty where do I find Sql Reproting services designer 2003 (had to rebuild my computer)
I had to rebuild my computer with .net 2003, i cant remembrer how I installed reporting services designer Please HELP As stated in the previous post, you have to run the install of reporting services 2000. You should have it on a CD On which cd sql server 2000 I do not see it there you have to install the sql reporting services client tools. i believe i just ran the setup as if i were going to install sql reporting services again, and there is an option to install client tools i believe. Where do i find the sql reportins service client tools for 2003, that is my problem. Thanks RS 2000 did not come as part of the ...Show All
Etowah_man Restore Databases in AS 2005 from CAB Files created in AS 2000
I have to restore some analysis services 2000 databases on AS 2005. Is there some tool which can perform this Hello, I understand that the solution of Artur will work, if you have access to the relational database from which the cube is calculated because when you finish migrate the cube it has to be recalculated. I have the same problem (a few cubes that I’d like to try in 2005, but I don’t posess the access to the relational database). Is there any way of migrating the cab without the access to the relational db Regards I have CAB files being created by another team. Previously i used to restore them on my SQL 2000 Analysis Services using msm ...Show All
dindelus help with create index error?
This is all I have, since the script was run last night, by someone else: was getting "cannot create index" on the tables, with a message referencing a maximum of 256 column indexes (which apparently includes system-generated statistics). THese are huge tables - milllion+. The indexes were single key values, and there aren't very many on these tables to begin with. Negative unallocated space was at -70GB, on a database that is 156GB. Why did this happen, anyone All the information I have is what's here, that and the fact that after 'deleting statistics' it ran. They rebuild the indexes every night, no problem. Obviously, they don't run updateusage very often. Auto update stats is on even though it's a reporting da ...Show All
Rob Ainscough MS Access Backend Link issues
Hi Guys I have attached an access database to my SQL Server 2005 as a backend. But there is a query which does not seem to be working. I have used forms in my access database and the query is as follows select lookup_Staff.staff_name from lookup_staff where (((lookup_staff.team_ID) = Forms!Frm_User!txt_team)) order by Lookup_staff.staff_name Can you guys help with that Thanks Mita Hi Mita It would be really useful if you provide a little more information in the way of error messages etc... Thank, Chris. Hi Sorry for miscommunication. Yes, MS Access as Frontend and SQL as backend Thanks MIta Do you mean that you ...Show All
mNero FTP bad password
I'm trying to make an ftp task. I am able to make the connection manager. When I test the connection it works fine. When I set up the ftp task I am able to browse to the ftp site and select the file I want to download. However, when I run the task I get the following error: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed I have no idea why the password wouldn't be allowed when it let me browse the ftp previously. Thanks i was having the same problem. Actually I changed the Security->ProtectionLevel for the package to DontSaveSensitive, and then this problem started happening ""the password was not allowed". I reverted the c ...Show All
SCRunner SSIS Error message
I have an input text file on my local box and the SSIS package runs there. I am reading the first 24 characters of each row and populating a single-column table on a remote sql 2005 server. Her'es the werror message I get: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT ' could not be opened. Operating system error code 2(The system cannot find the file specified.). Make sure you are accessing a local server via Windows security.". I certainly do have Windows access to the remove server as well as the local server. (and I test out all my SSIS connections before using them). Can anyone clarify the me ...Show All
Manjuramu Same effect as Cross Join?
How can I achieve the same effect as a cross join (since the merge operator doesn't have a cross join) Situation is this... a flat file has some header and footer information that I need to keep and attach to each row. So for simplicity sake of an example lets just say header has only 1 thing we care about - a row that says DATE=01/01/06. I take the file and run a split to split into "Date" "Data" and "other" (other has all the throwaway rows in header and footer I don't care about). Then I use a derived column object to get all the columns out of the "Data". Finally I want to add that Date metadata back to every row in the data... I thought this would be an easy thing to do.. but I can't s ...Show All
Chugupta How to connect to AdventureWorks database
I'm trying to connect to the AdventureWorks sample database, after just installing it from the SQL 2005 setup. I was expecting it to automatically appear in SQL Server Management Studio, but it's not there. H ow do I get it to show up there -Alex While installing the SQL 2005 setup, by default the sample databases option will be disabled. You have to explicitly enable this option to install the sample databases. refer this KB http://msdn2.microsoft.com/en-us/library/aa992075(VS.80).aspx Madhu You may not have installed them. If you go through SQL Server 2005's setup, you need to select the sample databases option. Paul A. Mestemaker II Program Manager Microsoft SQL Server ...Show All
AlexanderJ Always showing the parameter input area.
Greetings, Is there a way to force the parameter input area to always show even when default values are specified I want to always display the parameter area even when I set initial parameters. Thanks "Prompt" properties of that parameter is blank Thanks for the reply. I have not checked the forum in a while nor have I found a workaround. This is not a drill through report and the prompt string has been specified. I am working with 3 parameters and only one is a prompted parameter. P1 Integer - Internal - No available values -default value of 0 - non-prompt P2 Integer - Hidden - No available values - default value comes from quer ...Show All
Student417 MSRS & Active Directory Query
Using the Active Directory OLEDB provider I am writing a report to pull out some info from AD. Here is a sample: SELECT cn, displayName, Description, Mail, Title From 'LDAP://ourdomain' WHERE objectClass='user' AND objectCategory='Person' order by sn We store some important information in the Description element. When I run that Query against AD I get back values in all elements EXCEPT the Description element. What I get there is the following: <Binary> Granted, that is in the Data tab when I run the query. When I preview the data using a table object I get back errors on each row for that field. Any suggestions The values that are in that element are just text descriptions and not really Binary. Any suggestions ...Show All
Kalcy Suppressing text messages
When I run sp_start_job I get the message 'Job... started successfully!'. As I execute the procesure many times my logg fills up with these messages - is there a way to suppress these text messages Rgds Bertrand Try setting the output_flag to 0. It says reserved, but it indicates that it works in the definition of the procedure. I tested it and it was silent for me: msdb .. sp_start_job @job_name = 'test' , @output_flag = 0 How obvisous... :-) Thanks! Bertrand ...Show All
Luis Esteban Valencia Mu&#241;oz Install SSRS on different IIS server??
I am trying to keep my production SQL server very pure, and would like to install the SSRS IIS portion on my production IIS server. 1. Does this make sense to decouple the locations (keeping the servers dedicated to a single function) 2. Will MS let me do it I was thinking that I could install just the SSRS portion on the IIS box, but am looking to see if anyone else has experience with this. If I'll be bucking this decision forever... let me know your thoughts... Thanks! Dan I'll answer this myself from most recent experience.... My environment looks like this: SQL Server 2005 Standard x64 in Windows Server 2003 (Box 1) IIS Server x64 on Windows Server 2003 (Box 2) ...Show All
&#193;lvaro Pe&#241;arrubia How should the non-clustered index be created???
Hey. I've a table with about 18 columns Many of the queries which are made on this table include 4 or 5 columns in the where clause and thesame query has 5 or 6 of the other columns in the select clause. Somebody has created about 11 indexes, 1 for each column...In essence the query would look like this select col1,col2,col3,col4,col5 from table1 where col6=100 and col7='test.exe' and col8 = 'helloWorld' I am thinking the index should be built on all 8 of this columns in SQL 2000. Also, in SQL 2005, I know I can use included columns for this but can someone tell me what columns should the non-clustered built on and which cols should be included Thank you. You are c ...Show All