Answer Questions

• chsaia Cast from string to date

  I created an SSIS package that pulls in legacy data from a DB2 AS400. There is an In Date field that is stored on the AS400 as OdbcType.Date or DATE. However, when I use SSIS to pull in the data, SQL wants it to be a string so I gave up and let SQL have it's way. Now in my SELECT statement, I have this: SELECT TLMST.TLNUMBER, TLMST.DOGNAM, BRDMST.BRDesc, TLMST.INDT FROM TLMST INNER JOIN BRDMST ON TLMST.BRDCOD = BRDMST.BreedNumber WHERE (TLMST.INDT >= @startdate) AND (TLMST.INDT <= @enddate) ORDER BY TLMST.INDT, TLMST.TLNUMBER Because I see the dates stored in TLMST are yyyy-mm-dd format, this is not working. It is not pulling any records. I tried to use the CAST statement but I keep getting errors about c ...Show All

• milton howe Partition table in SQL 2000

  I have a table about 300 GIG and I want to partition this table into several filegroup. Is this possible in SQL 2000 Thanks You might want to redesign your tables then migrate the content to the new design. A distributed partitioned view can be used like what Kevin mentioned. Partitioned tables are a feature of SQL Server 2005. In SQL 2000, you can use distributed partitioned views, but that isn't the same. ...Show All

• Sweeps78 Install Sql Reporting Service - Windows 2003

  Hello I need to install the SQL Reporting Service in one Windows Server 2003, my schema is: One DMZ (Servers Web with II6/Win 2003) One SQL Server (Sql Server 2000) When I install Reporting Service in the step about SQL Server Configuration the SQL Server not make de authentication, the message with the user dont have permiton! I view the SQL Log with show the problem with not use Kerberous comuniction! Tks a lot Hello Alex, I have a similar situation.  I have a Windows 2003 Server in a stand-alone workgroup configuration on which I installed SQL Report Services.  This Server is in a DMZ and the SQL Server I am trying to connect it to is on our internal LAN and a Domain member Server. From the way you describe yo ...Show All

• Dorian Dechant Installing two instances of Report server

  Can we install two instances of report server on the same machine . We want to use the same hardware for two different methods of custom authentication. Both the server applications would then talk to the same database. cvajre, Here's a step by step way of implementing 2 reporting instances. http://bloggingabout.net/blogs/mglaser/archive/2006/12/18/multiple-reporting-services-instances-on-one-machine.aspx Ham ...Show All

• No.1 Of Mew Deploying to subfolders from VS

  I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here I am actually looking for a way to do this from the IDE as well. Currently we create the folder from the report server portal... then in VS Right click the report project and update the report server folder. i.e. if you were deploying to MyReports you would change it to MyReports\<New ...Show All

• Kmbhat Accessing SQL Server 2005 Express

  I recently downloaded SQL Server 2005 Express Edition. Everything was installed correctly without any problems. However, when I went to my Program list, the only thing listed for Microsoft SQL Server 2005, was Configuration tool. Where is the actual program where I can write and run queries How do I access the server I think that the 'default' installation only installs SQL Server. If you want the client tools, you will need to insert the media again and select Client Tools (or something like that...) The Express SKU does not include the client tools you are referring to. If you want to install these, you need to download Express Advanced and add Management Studio Express. This will give you the U ...Show All

• soconne Newbie question: INSTEAD OF triggers

  Hi, I’m familiar with Firebird and PostgreSQL DBMSs, and now I'm exploring SQL Server Express 2005. In other products you have both BEFORE and AFTER events arround INSERT, DELETE, UPDATE. I'm not sure if I understood well INSTEAD OF triggers, but these would be equivalent to BEFORE triggers Can you give me an example on when I'd use INSTEAD OF triggers Thank you, Guillermo Sure. Imagine to have a view which is not updatable due to insufficient key columns, the you would have to implement your own logix to update the data. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- hi Guillermo, Jens already answered... just a side note... INSTEAD OF triggers are not ...Show All

• japt Initialize Subscription Failing

  When I create a subscription for a Publication I am receiving the following error: Concurrent snapshot for publication <Name> is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. The snapshot has completed, and I have recreated the snapshot multiple times. The Log Reader is running without apparent problems, but continue to receive this error message. Does anyone have any ideas why this error is occurring Looks like the logreader agent is not activating the snapshot for some reasons, you may want to try the following: 1) Does logread.exe show up in task manager at the distributor You may want to check when was the last time the logreader agent log a history m ...Show All

• Cheung Ho Man sql 2005 install error. MODIFY FILE failed. Specified size is less than current size.

  I installed sql 2005 a while back. Then I recently found out my file system was fat32 (I don't understand why the hardware people did this...) and I had to convert to NTFS. Naturally the sql service no longer worked so I uninstalled inorder to reinstall now I can't reinstall it I keep getting this message native_error=5039, msg=[Microsoft][SQL Native Client][SQL Server]MODIFY FILE failed. Specified size is less than current size. I'll try to post the full log in a new post. Try remove or copying off the old database files from \Microsoft SQL Server\MSSQL.{X}\MSSQL\Data folder before reinstalling. If this does not work, supply us the setup log files at C:\Program Files\Microsoft SQL S ...Show All

• SolveIt To Pivot or not to Pivot?

  Greetings SSIS friends, Consider the following example : I have the following data : betting_opportunity----------result_number----------result_id 559632-----------------------4----------------------2763415 559632-----------------------0----------------------2763416 456617-----------------------1----------------------2763423 456617-----------------------3----------------------2763424 what I want to do is display the data like this : betting_opportunity----------final_result 559632-----------------------(4-0) 456617-----------------------(1-3) I have done the SQL code for this no problem but I want to do this using SSIS components but I am totally stuck! Any advice would be appreciated! Hi Phil, I suppose I c ...Show All

• TheQuietShadow Possible to add a Flash Player control to a report?

  I'm working on a project where the client wants us to create custom charts which have features not found in the standard Reporting Services charts. I would like to use flash to build this and have found an existing flash charting package for which I have the code and which I plan to expand. Here's the problem: The client wants to include these charts in his Reports. Is there some way to add a flash control to a report so that it will appear on the web page as a fully-functional flash presentation, which can then be included when printing or exporting The alternative, would be to figure out some means of generating the chart using flash outside of the report, exporting a bitmap of the chart and then saving the bitmap to a known location o ...Show All

• robertmundinger Enterprise Manager for SQL server 2005

  Hi, i just installed sql 2k5 server and client tools. When i run SQL ServerManagment Studio i dont find a way to create database. Sajajd Right click Databases. It will give you the option to create a new database. Adamus First thing you have to do is to connect to the server so that you can view the system in the object explorer... once there expand the server so that you can view the database tab and as above right click and select create database or new database. ...Show All

• dreameR.78 Dts Package foreach loop container and Excel connection manager

  How can I use a foreach loop container with an Excel connection manager. It is virtually impossible to configure the ConectionString property through expressions builder. Everything works fine with a Flat File connection manager but when it comes to Excel, I get the following error message: Error 1 Validation error. Extract Four: Extract Four [1]: The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. Tarification.dtsx 0 0 Please ! Heeeelp ! tel me how I can loop through Excel files ! Hi, When you set up a foreach loop you can set the a variable mapping using index an index value of 0 to map to a preset variable of string ty ...Show All

• Daudi Delete Multiple IDs

  Hi, I am getting doubles for all my IncidentIDs in IncidentID column. Ex: Incident ID 13734 Incident ID 13734 Is there a delete statement to get rid of more then one Replication of the same ID Thanks I tested the procedure again, It is working as desired Let me know the Exact sql statements you used try like this select * into #temptable from yourtable Go Delete from yourtable Go Insert yourtable Select distinct * from #temptable Go Drop table #temptable Can you provide me your table structure and sample data i excecuted the s ...Show All

• Yogesh Shah Real size of database

  I have a database which I do not think is really big, but when it was created the initial file sizes where set to very large amounts. How do I get the actual size of the data When I do shrink database, SQL say there is no space to reclaim but when I back it up the backup is extreamly small, does this mean that shrink database will not shrink past the original size How do I resize the database to only the actual size needed Here is the result of sp_spaceused: database_name database_size unallocated space -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ CCCca 99863.81 MB 96318.27 MB reserved data i ...Show All