Answer Questions

• Brian Gray Replace column value with MAX() query in dataflow before insert

  Hi, We have a dataflow task that imports data from excel to a sql2005 database table. One of the columns is never filled in in the excel source. For updates we can use the lookup transformation to fill in that column, but for new values we need to calculate a new value for it (it's a PK) with MAX(column) +1 and replace the null value in the dataflow with this new value. Just to be clear: column id (int) column name (string) Based on th ...Show All

• TiagoNobrega Dynamic Connection String

  Hi, Can I pass the connection string dynamically. That means the user will specify the database, he/she wants to connects to and user name and password for the same and display and list of Models/Reports stored in that database. Yes, you can. After all the ConnectionString is just a string. So before you make an SqlConnection, you build up the ConnectionString. string userName = "Joe"; string password = "* ...Show All

• BikramS Strange Problem

  Hello, I use a web replication from a web server to a database server. When i launch synchro with IE Synchronisation manager, it works fine but when i try to launch it with SQL Server Agent, i get this error : Date 15/03/2006 17:09:25 Log Job History (GINGKO\SQL2005-TestGestionSIE-ReplGestionSIE-S15208507-Replica_GestionSIE- 0) Step ID 1 Server S15208507 Job Name GINGKO\SQL2005-TestGestionSIE-ReplGestionSIE-S15208507-Replica_GestionS ...Show All

• NormM Where is SSIS?

  I just upgraded my SQL 2005 installation to include integration services. Now I can't find the service. Where is it Business Intelligence Development Studio is installed with SQL Server Tools option. That was it - I didn't think about the tools part. Thanks. In you start menu, under "SQL Server 2005" do you see "SQL Server Business Intelligence Development ...Show All

• Ram Marappan I can't deploy a solution

  I installed April CTP 2005 in a new computer and I can't deploy an existing solution which works in the old computer. When I deploy it give me Error -1056899072 with no messages. If I make a new solution then it works fine. I'm sure the problem is with the datasource. Because when I try to deploy with june CTP give an error: "no se ha efectuado ninguna asignacion entre los nombres de cuenta y los identificadores de seguridad" and in English i ...Show All

• Proachbass91 How to/is it possible?...

  Hello, Im new to reporting services,sitting here with the "hitchikers guide" book, and got some unanswered questions. What im trying to do: I have finished the report layout, it has a table with 6 columns for holding client specific information. Each client of mine will then get this report emailed to them. The sending of the report to each client is not a problem, i understand how to fetch the email addresses to send to, from my mssql database. ...Show All

• Slamhart Table partitioning with multiple keys coulmns

  Table partitioning with multiple key coulmns Hi champs! I have one table with around 600 million records. I want to partition this table on 5 different coulumns. year, month. coulumn3, coulumn4 and coulumn5. How do I do this best What is the best way of doing this; is there any best practice on ths The obvious thing is to make a partition funktion based on the year and month coulmns, but I also want to partition on coulumn3 ...Show All

• phillee Add a DateLoaded column to input data

  OK, I *know* this is trivial, and please feel free to giggle,  but after years of DTS 2000 my poor brain can't make all the jumps neccesary to cope with SSIS 2005. I have a Transfer data task. Source input (non SQL Server) has x columns, SQL Destination has x+1 columns, where the extra column is a non-null smalldatetime column DateLoaded. This will be populated with the Date & time the row was added. In DTS I do this either by adding a ...Show All

• Janne W Could Not Bulk Copy

  Hi: I am doing a full snapshot on couple of subcriptions but getting this message from last couple of days. I have to do this at night because tables are very large so it does not block the users. I am not sure which table this error is happening. It used to work fine but from last couple of days this has started to happen. I need to re-sync my subscription database with production database but some of the tables are giving problem. The pr ...Show All

• likong Transactional Replicating hanging SQL Server 2005

  Hi, It appears that every 5 or so days, my transactional replication is hanging.  I see that I have a couple thousand undistributed commands and this number keeps growing.  It forces me to generate a snapshot in order to sync up.  When generating the snapshot, I will get frequent messages like "waiting for a response from server...".  So I will keep stopping and starting syncronization.  Eventually the snapshot will g ...Show All

• Nate Walker How can i debug triggers in a SQL Server Project?

  Hello, where can i read about using .Net language triggers in SQL-Server 2005. If i try to set a breakpoint in VS-Studoio and choose Debug/Attach to Process i get the Message "The breakpoint will not currently be hit. No symbols habe been loades for this doucument." And what is the correct syntax for the SQLTrigger Attribute Partial Public Class Triggers   ' Enter existing table or view for the target and uncomment the attribute ...Show All

• Dev_Moud Reporting services forms authentication problem

  Hi I am implementing forms authentication based on the MSDN article. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsq ... i got steps working for register the user,logging successful,when redirecting the url.i am getting this error. The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Can any one help this issue. ...Show All

• justme2005 Problem using dates in XMLtoFLFF Transformation

  I am having a bit of trouble transforming a XML (xs:date) type to the DBDATE in my FLFF. I believe the problem is because the SSIS DF (Metadeta) converts xs:date to DT_DBTIMESTAMP which becomes 01/01/2005 00:00:00 -- appending the time. So when I try to transform in my fixed length flat file, it throws a truncation error when the length is set to 10. (which is the length of date) Is it possible to (A) use some other xs format that ...Show All

• rawdrib Parameter Available Values

  If I have a paramter that has query based available values, how do I get it to use a connection string specified in another paramter to do the query The scenario is that I have one set of reports that pull from a number of databases that have identical schemas and each serve a different customer. i need to be able to somehow populate the valid values with the right data from the appropriate database at runtime. ...Show All

• chrism12 Debugging a worker thread inside SQL Server

  Hi Everyone! Just started looking into Assemblies within SQL Server in the hope of creating a multi-threaded application and when writing a basic test assembly I came across the following problem... When I create a worker thread within my assembly I am unable to do the following in my newly created thread: Stop on a breakpoint in VS2005 Use Debug.Writeline to output to the output window I know the thread is running as I am able ...Show All