Answer Questions

• grover2 Execute a package on a remote server

  I want to execute a package that's found on a remote server as MSDB. The execute package task locally is not allowing me because i don't have a login permission i guess because i'm not on the same domain and my user account doesn't have the neccessary privelages to access the server. However i can execute sql statements and data flow tasks on the same server. Isn't it possible to use the login and password of the sql server i ...Show All

• Bobby123 How to export a table column of XML type to file?

  How to export a table column of XML type to file when I use international characters in values of XML parameters Thanks for an answer. Thank you very match for your answer. It was about “-w” parameter.   With regards Jiri. Hello, You can simply use bcp.exe to bulk export/import XML data. If you use the "-w" flag, the XML data will be serialized as wch ...Show All

• tfif view scripting - what happened?

  I just loaded 2005 Developer after using 2000 Standard for quite awhile. I went to script views using the new Server Management Studio and things are definitely different: 1) No ANSI / Unicode options; it looks like everything is Unicode (bad move). 2) All this extended property junk ( EXEC sys.sp_addextendedproperty...) is now generated; is there any way to turn this stuff off And what is the point of it anyway Thanks ...Show All

• William Vaughn System.Windows.Form assembly is needed on script component task?

  That affects only interface design... so that it doesn't exists at all in a SSIS. What is it for Let me know your view on this or any clarification. I'd say it is compulsory, since you cannot remove it. Why that is I am not sure, probably a limitation of VSA, the slightly quirky host environment used. It is usefull for MessageBox calls through :) Darren, you're right. At least for that. Not sure - what do you mean i ...Show All

• RogerJD Connection managers - OLE DB

  Hi There Quick question.In DTS when you had multiples tasks connecting to the same Database, it was reccomended that you create multiple connections for the same database and let each task use a different connection, thereby making a new connection for each one. In SSIS if i define 1 OLE DB connection to a database, but i have say 6 tasks using that connection that run simultaneously, does eachone open a new connection to the database to make it ...Show All

• Eliasoft ado connection

  i have developed an application that connects to SQL Server 2000. on my machine as well as 90 % of our company's machines it works fine. but the rest (xp machines) it doesn't want to work. it keeps telling me my provider is not installed correctly. i have tried various installation of mdac but they don't install. i see on msdn they say it could be a localization error but the workaround they give doesn't work. what else can i try ...Show All

• justicelin Server Error Trying to Connect To Local SQL Database

  I get the following server error locally, when trying to connect to a local database. I paste the connection string using the properties panel in vs 2003, but I can't seem to get it to connect and pull data. The furthest I get is pulling the column names into a datagrid, but no data. The server error is sporadic. Keyword not supported: 'provider'. Here is the code, thanks for any guidance: Imports System.Data Imports System.Data. ...Show All

• jam201984 SAN Replication

  I'm wondering if the technology exists to use SAN replication for sql server 2005 disaster recovery. I have a bunch of prod servers I want to add to a san, I then want to have another bunch of servers at a dr site connected to another san. Is there a technolgy ( non sql ) to enable full ( real time ) san replication of the data ( for SQL Server databases ). I don't need alternate suggestions, this solution has been proposed to my client ...Show All

• Numan azam Datareader Query Timeout

  Hello, I am running a query via a ado.net data flow source. It works great for a small number of rows, but if I try to execute a long running query it times out with a communication error. I have looked through the doc and every property sheet that I can find in my package, but I can't find anywhere that a timeout is specified. Any help on finding this would be appriciated. The query is running against DB2 on z/os and I know it is timing ou ...Show All

• Vin.jr Need help on Combine both Avg() and Max function?

  Hi dear all, anyone can help me or guide me on how to use both avg and max function togather. or any other solution to solve my problem now i have a set of score, that is seperate into many day. so now i can get the average score for everyday. but now i also want to know which day is the highest score and min score. and sql not support max(avg(score)). so what should i do on it my table name is answer. i group it using the date colume. ...Show All

• Lambros Vasiliou Dynamic loading of a file

  I've been told by Kirk that it is possible to load a file whose metadata is unknown at design-time by using bulk insert along with a file (not a flat file) connection. He didn't elaborate though. Can anyone explain -Jamie no transformations on the tables- just a straight export number of tables- that's part of the the problem i am trying to solve- I want the number of tables we can export to be arbitrary- we have probably ar ...Show All

• brucef INCLUDE Clause

  Im trying to decide if I should or shouldnt use the INCLUDE clause on indexes in SQL 2005.. Or if I should continue creating standard covering indexes. I care mostly about the performance differences.. If anyone could share a definitive answer I would really appreciate it.. Thanks, Paul Cool.. Thats what I was thinking as well but I was wondering if there was something I am missing..   NNTP User ...Show All

• Dilip Krishnan Updating database workflow question

  hi, i have a simple database. to test it i have the database locally and i have the same database in the server. currently when i update the database i copy the whole database (mdf file including the data) to the server. i would like to copy only the tables and not the data to the server. what is the best and easiest way to do it regards, rnv Hi Rnv, SQL Server 2000 2005 2005 CTP Anyone offering additional feedback, ...Show All

• Dirk Volatile parent key

  I get this message every time i start Server Management Studio Express CTP, i have lates download ie 11/11/2005 V2. Can not create a stable subkey under volatile parent key. I click continue and Server Management Studio Express CTP seem to start OK. Can you help with this. I had the same problem fresh after installing SQL Server Management I loaded it and got that annoying Volatile parent key message with no ot ...Show All

• CraigLee Potential workaround for SP1 failure

  SQL Server installation fails with the message: "A recently applied update, KB913090 failed to install" The last executed task was: Integration Service The last installation message was: Checking for lock files via Windows installer sqlrun_tolls.msp I also am receiving the error message: "A recently applied update, KB913090 failed to install" And here is the contents of the log file you referenc ...Show All