Answer Questions

• Andreas Asterlund Custom Source Component Problem?

  Hi,I have developed a custom source component to get data from a generic odbc connection with some special caracteristics. The component works fine by getting and mapping the output fields etc... The only two problems existing are that when i run the task it says that the data flow has no components inside... how is this possible since i have my source mapped to a flat file inside that data flow This is the error: SSIS package &q ...Show All

• rogg Programmatically extending the project tree

  Hi, I need to write an add-in, that when installed it will add a virtual folder to the project tree (in which I can later add other stuff). The problem is even more complicated since the project I want to extend is an SSIS project (SQL Server Integration Services), and it doesn't let you customize the project structure even from the project explorer itself (can't add folders). I appreciate any help on this. Thanks. ...Show All

• vizca How connect SQL server 2000 with c#.net .....?

  Hello masters, help me yaar i am using dotnet 2003 and SqL SERVER 2000. BUT UNABLE TO CONNECT DATABASE using dataAdaptor(design time ) or sqlconnection any can help me gs whats the error lets see the connection string. make an empty text file called "c:\test.udl" - double click it and try to build a SQL Ole Db Provider datalink. . . can you get that to work Are the TCP protocols enabled in your machines clie ...Show All

• mikelaw Font object saving and retrieving

  Let's say a User selects a Font from a FontDialog, and the selection is assigned to a Font object. How can I save the Font object to a SQL database, and later retrive it restored to a Font object Thanks in advance. What I meant by "How do I serialize to a datablase ", I think boils down to "How do I get it into a binary parameter " Seems more like a q ...Show All

• RajatTalwar SQLSTATE=08501 - or - Communication Link Failure

  Hello, Was just trying to solve an issue that keeps coming up periodically. We are using PowerBuilder v9.0 as our front end and MS SQL Server as our back end. We are using ODBC as opposed to using the Native SQL Server Database driver that comes with PowerBuilder. We have a process that runs hourly throughout the day, everyday, and about every two weeks we start to get strange errors coming from this process. Most notably, the following error me ...Show All

• Amir Goodarzi Reporting Services vs Crystal Report

  Does anybody know what is Microsoft roadmap for reporting tool, e.g. between Reporting Services and Crystal Report Vincent Don't really understand what your asking about Vincent...could you clarify a bit if you get a chance Thanks... Chad, as both Crystal and RS own by Microsoft, I would like to know if there is a plan to merge them and what would be the surviving product. In particular, in our BI dan D ...Show All

• Brian C. Slowly Changing Dimension Task Bug???? [:S]

  I am working with the latest build of SQL Server 2005. VS 2005 8.0.50215.44 (beta2.050215-4400) SSIS version 9.00.1187.00 I had a package that was working fine while using the Slowly Changing Dimension Task. However, with the new version the Historical Attribute for the type II change does not work anymore. I’ve created a very simple test and while running the same package twice, without make any changes to the staging table, I ended up with d ...Show All

• singhhome How to create Merge Replication with latest update always from subscribers

  Hi , I am trying to create Replication Topology (Merge Replication) like below. Subscriber1 --> Publisher <-- Subscriber2. I have created both subscribers with Subscription Type as Server with Priority as 75. I am updating the Column A of Row_10 in Subscriber1 on time say 11 am. After i am running the Starting synchronizing agent from Subscriber1. The value propagated to Publisher now publisher contains the latest value in Colum ...Show All

• Kaspergyselinck Is this possible?

  Hey guys, I wrote a T-SQL query to retrieve all errors name and count the error for each error name based on some conditions. Assume that errors_name is a column name in Error table and the error_count is a calculated field. Here is my question; when I run the query, obviously, it displays the list of errors name and the corresponding errors count which only meets the where condition . However, what I need is to list all the errors name (eve ...Show All

• Manuel_0001 xp_sendmail does not send the mail

  Hi, I have a Microsoft 2003 Server, with SQL Server Standard Edition 8.00.760(SP3) installed. I am using Microsoft Outlook 2002 (10.2627.2625) like my default mail and I have defined a Outlook profile "AutoSend" to use with SQL Mail with a email account POP3 configured. In the Enterprise Manager, I assigned and tested this profile in the SQL Mail settings. It was fine. In Fact, when I send a mail with xp_sendmail to my emai ...Show All

• Ealdormere This SMO transfer script doesnt transfer ?

  Hello, this takes a lot of time  but when I got to sql server management studio there are no objects there!! What am I missing private void button1_Click( object sender, EventArgs e) { Server sv = new Server ( "ESTACION15" ); Database db = sv.Databases[ "GescomDllo" ] ; Database db2 = new Database (sv, "PRUEBA" ); // db2.Create(); Transfer xfr; xfr = new Transfer (db); xfr.CopyAllObjects= true ; xfr.C ...Show All

• osubvr Neither the partner nor the witness server instance for data...

  I am getting this error while trying to setup mirroring. "Neither the partner nor the witness server instance for database "shop" is available. Reissue the command when at least one of the instances becomes available. (Microsoft SQL Server, Error: 1431)" I am just using principal and mirror server, there is no witness server. I have tried fully qualified name and ip for the servers also. I can connect from the principal s ...Show All

• davidoweissman Whitepaper about locking?

  On the Launch tour Christian Kleinnerman explained  not in deep about locking and isolation levels, I would like to read a lot more about this because in my application is very possible that many users read the same row or try to update the same row. Thanks    Have you looked at the latest Books On Line. We have lot of useful information there. From your question, are you referring to concurrent writers In that ca ...Show All

• yimin chen Management Studio Express CTP regular express replace bug?

  Open a document and try the following regular express replacement. Replace {:i} to \1 bla bla A lot of wrong replacement. (BTW, I do the replace in a selection.) It's possible I'm misunderstanding the editor technology, but I think the first match found in the regular expression is called \0.  \1 would be the second. I did the following on my machine: 1) Start an editor 2) Type the following: A PROVISI B ...Show All

• Pliers Which edition of sql server 2005 to use?

  Hi, We have a scenario wherein we need to have a sql server 2005 on one machine and the BI installed on other machines(clients) which are less than 10 in number.Is it possible to use the sql server 2005 developer edition in this scenario Our requirements only involve development and testing. If we can use developer ed. then how many CAL's(Client Access Licenses) come with this edition. thanks If ...Show All