Answer Questions

• galbox20 Error: The product level is insufficient for component, while executing SSIS package

  While executing SSIS package from command prompt as follows: dtexec.exe /DTS "\MSDB\etl-hyundai-package" /SERVER tvmwindev02 /CONNECTION "TVMWINDEV02.HISNA_POC";"Data Source=TVMWINDEV02;In itial Catalog=HISNA_POC;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E /CONSOLELOGO while executing the package following error message is received as : Error: 2006-07-28 15:12:36.60 Code: 0xC00470FE Source: Data Flow Task DTS.Pipeline Description: The product level is insufficient for component "Data Conversion" (202). End Error and at the end as : DTExec: The package execution returned DTSER_FAILURE (1). Same ...Show All

• Thanh Duong Where Find SQL Server Agent

  Dear All, I have installed SQL Server 2005 Express Edition, Iam not able to find SQL Agent, So anybody help me............................ Regards, Vinayak In MSDE 2k there was no SQL Agent either. The most proper way to execute scheduled jobs was to write a file with your SQL Script to execute and schedule this with a scheduling service like AT / WINAT. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- hi Vinayak, Vinayak T wrote: Hello, Can you provide few examples of jobs, scheduled jobs/maintaince Jobs.... As iam new to SQL 2005........ try having a look at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=590766&SiteID=1 if helps.. regard ...Show All

• AlexBB color subreports in layout view

  Is it possible to color the subreports a color other than gray when working in the layout view only I have a report with several subreports and want to make it easy to distinguish. Thanks. ...Show All

• GeorgeBH Data Flow Task - Conditions to add value for a field.

  Hi: I have a data flow task in which i have multiple OLEDB sources going to a one OLEDB destination via UNION component. I also have a derived column component sitting behind the union, because there are some columns, which exist in the destination table, but are not coming from source, but I am responsible of providing values for those fields. The question is that some of those values are conditional, for eg. Lets say we have a column called RecStatusCode in the derived column component. The value for that column depends on a condition/criteria, so I need to query a db and based on the value of another field, I set the value of the recstatus code. How do i accomplish that I am thinking expressions, but I need clear direction in steps i ...Show All

• jsale_endeavor StrToMember performance issue

  I am building a parameterised report against a cube. After starting with an MDX statement that performed perfectly well and parameterising it the performance went downhill fast. I was able to replicate similar symptons against the Adventure Works cube. In this example I am getting sales values at 2 different dates and breaking them down by Sales Territory and Customer Geography dimensons. In fact they could be any dimensions, but I do need to add a crossjoin in order for the problem to show itself. WITH MEMBER Measures.FirstDateAmount as --([Date].[Date].&[32],[Measures].[Internet Sales Amount]) ( StrToMember ('[Date].[Date].&[32]'),[Measures].[Internet Sales Amount]) MEMBER Measures.SecondDateAmount as ([Dat ...Show All

• Perry Choy trying to connect using forced encryption

  Maybe someone can tell me what I am doing wrong: I created my own SSL certificate and installed it on my server. I wrote a really simple VB.NET program to access the SQL Server using encryption. The connection string works fine inside my building (on our network) but when I take the application outside of the building and try to connect it fails. Outside of the building, I add Address=xx.xxx.xxx.xxx,1433; to the connection string. The attempt gives me the error: a connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an untrusted authority If I remove the encryption=True from the connection string, everyth ...Show All

• carlp22 Add parameter to "navigation" url

  Add parameter to "navigation" url - Hello, I'm trying to add a parameter to my JUMP TO URL but it doesn't work. basiclly i'm useing javascript there: javascript:window.open('http:www.a.com num=XXX'); i want to change the XXX with a value from the dataset. I tried - javascript:window.open('http:www.a.com num= + Fields!ME.Value '); or - javascript:window.open('http:www.a.com num= & Fields!ME.Value '); it didn't worked :( any help hi, you dont need any javascript or anything. in the jump to url just give " http://lsd.catchcom.com/sok/service_info.php item_id "= & Fields!CATCHREF.Value The reason why you might get that error is probably becuase the filed!catchref ma ...Show All

• Kamii47 How do you open an Express project in Standard?

  I developed a project (web application) using the Express editions. How do I migrate the project from Express (SQL Server Express & VWD Express) to Visual Studio 2005 Standard and SQL Server Standard Thanks if you can answer this. Ken Hi Andrea, Thanks for your reply. I eventually figured out how to create a new connection string and so I can now open the Express project in Standard. Within the context of deployment to a hosting service: Under what circumstances would it make sense to "convert" my Express project to be a "full SQL Server 2005 " project. And if it is a good idea, how do I convert it Ken hi, ...Show All

• heffer0831 Error in Transacitonal Replication - SQL Server 2005

  Hi, I'm deploying tran repln between 2 SQL Server 2005 databases and when viewing the 'Distributor to Subscription History' see a error message: Incorrect syntax near the keyword 'where'. (Source: MSSQLServer, Error number: 156) On the subscriber, I don't see the snapshot being generated....Please advice. Thanks! Ray I was looking through the notes for the SP2 CTP November release and I didn't see anything that mentioned that the problems with Replication were addressed in this Service Pack. Eric Yep, this is fixed in SP2, you can pick up the CTP here: http://www.microsoft.com/sql/ctp.mspx -Raymond ...Show All

• Paul Fuhrmann Got Started But Not Really: SQL Server does not allow remote connections

  I downloaded VS studio express, and created a personal website using the wizard to test drive the thing. When I hit ctr + f5 to run the sample provided, then I get this message: " An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) " I tried disabling the firewall (Norton's firewall because Windows is disable always). Any suggestions This is a brand-new machine, running XP sp2, just downloaded the VS studio express. I really appreciate your inputs. Regards, Ca ...Show All

• Noah Nadeau Merge rep. over internet with adsl connection

  I want to set up merge replication over internet between sql servers located in different cities. Servers have adsl connection. Also I want to start replication witout synchronizing. Actually what I want is starting replication without snapshot because of connection issues. How could I achieve connecting approximately 40 server in this way What about starting without snapshot As far as I know even if I choose "already has been data and schema" snopshot agent starts and this is a potential problem. Running snapshot agent and then Merge agent applying these snapshot files are different. Snapshot agent runs at the distributor/publisher and generates the file ...Show All

• Shady9399 Importing data from one source in two destination tables linked by a foreign key

  Hi, I have a new problem when I import data from an xml source file in two destination tables. The two tables are linked by a foreign key... for example : table MOTHER (MOTHER_ID, MOTHER_NAME) table CHILD (CHILD_ID, MOTHER_ID, MOTHER_NAME) After a lot of transformations data are inserted into MOTHER table and I want to insert other fields of the data flow in CHILD table. To do this, I need the MOTHER_ID field that is auto incremented in MOTHER table. My problem is to chain the insertion in CHILD table after the insertion in MOTHER table to be sure that the relative row in MOTHER table is really inserted. I haven't find any solution to chain another transformation task after my flow destination "Insert into MOTHER table& ...Show All

• setuc FTS Catalogs won't populate

  Hi After creating a full text catalog in SQL Server 2000 and performing the initial population, the catalog say has an index count of 1 (should be several thousand) and all "contains" queries return no results. The gather log contains the following error message: Error Fetching URL, (80070002 - The system can not find the file specified) . Any catalog I try to make has the same problem. All catalogs were working fine last week. Any help would be very appreciated. Thanks! Our DB is on a cluster too. I will definitely try your solution tomorrow and see what happens. Thanks! Hey, we fixed our problem by re-registering tquery.dll on SQL Server. See http://sup ...Show All

• QWERTYtech I need to change the name of a field...

  I need to change the name of a field in a db hoy can I do so USE <db name> GO EXEC sp_rename '<table name>.[org. field name]', '<new field name>', 'COLUMN' GO ...Show All

• Nep23 copy file

  hi guys, anybody know the syntax in SQL to copy file to other server. we want to copy our db backup files automaticaly to other server. thanks -wei hi dedy, hi try mapping " \\server1\folder1 " to qa drive letter to map 1. open windows explorer. 2. click tools. 3. clcik on map network drive 4. enter necessary permission you can assign a specific user (using different username option) to your mappings to make sure you wont run on a permission problem with NTFS run exec xp_cmdshell 'copy c:\folder\test.xxx x:' ---<--where x: is the mapped network drive regards, joey hi, I want to copy file to other server us ...Show All