Answer Questions

• WHairston SQL Server 2005 Remote Connection

  This has probably been answered before, but... I have a local SQL Server 2005 instance running, and I would like to have another user on my network connect to this instance. However, when he tries to connect, he always receives the same error message: "An error has occured 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 ...Show All

• Davidwv Interesting Transactional Replication issue

  Hello, We have moved from SQL 2000 to SQL 2005 for our main server, and our reporting server, which uses transactional replication. Now, in SQL 2000 when I originally setup replication, it replicated all of the table indexes. I have recreated the publications in SQL 2005, but they are no longer there. Do you have any idea what would cause some of our table indexes to be missing What can be done to ensure this doesn't happen Thank you. ...Show All

• Johnson Road Doing a data import using DTS Wizard in SQL Server 2005 - being efficient with 5 flat files

  Hi, I'm a new user of SQL Server 2005. I have the full version installed. I also have SQL Server Business Integration Dev Studio installed. My OS is Windows XP. I'm importing a series of 5 flat files into a database on one of the SQL Servers we have. My goal is to get 5 different tables (though perhaps I should do one and add an extra field to distinguish each import) into the database for further analysis. I tried doing an import via D ...Show All

• thediehl SSIS error listing

  Is there a list of all the SSIS Error codes and what they mean Ex. -1071607778 is an error code output when a lookup task fails to find a match. I haven't been able to find any information on the different error codes. Is there a description file or enumeration file that exists somewhere My issue turned out to be string length. I have two databases A and B for the sake of discussion. A is a transactional dat ...Show All

• Andrew McCall Execution of Package failed

  I am trying to design package which would copy all tables and stored procedures from one server to another. It used to be simple task in SQL 2000, there was wizard. However the new wizard does not work... I wrote SSIS package, but when I execute I get the following error: "Can not apply value null to property Login..." Any idea It seems to me that this new SQl2005 is not that simple to use like 2000. 2000 was a great product. I am consider ...Show All

• bljacobs Slowly Changing Dimensions Errors (volume related?)

  Hello, We are having issues with SCDs that appear to be volume related. Small dimensions work fine. Pasted below is the last few lines of our package run without any contention (We get different errors at different time with contention referring to buffer or virtual memory). It seems to be calling out the SCD main task but just gives a number and not much of a description. 2) For the errors referring to a buffer ( I can paste them also bu ...Show All

• Oliviertje Writeback

  Hi i am trying to set up a cube with MS SQL Server 2005 that allows me to insert planing data. eg. i have actual data from 2005 and i want to insert figures for 2006. what i did: I have a cube with data from 2005, I enabled writeback in the partitions tab, precessed the cube and i went down to the leaves but i was not able to insert data when viewing the data with the browser. What else do i have to take into account Thanks, Klaus ...Show All

• Edward R. Hunter Stopping automatic reconnect of SQL tools

  Hi,    I've developed a tsql alert response stored proc. that will kill connections from specified developers if they connect to particular dbs using tools other than ones they are authorized to have.  It seems to work well for most applications like Excel and Access, but not for Query Analyzer and Enterprise Manager because the latter immediately reconnect after their session is killed.  Is there any way to stop this behavio ...Show All

• Gungmas exporting reports into EXCEL format

  Hi, My organization is currently migrating from reporting services 2000 to reporting services 2005. We are having an issue with exporting reports into EXCEL format. Basically we have a table with five grouping hierarchy. The parent groupings toggle the visibility of the corresponding sub groupings. It works as expected when deployed to the report server, however when exported into Excel it expands to level 4 even though level 3 was not actua ...Show All

• Nikhil27 Problems With SQL 2005 SP1 (x64)

  Hi, After installing SP1 onto our SQL x64 2005 box (running Server 2003 x64 R2), I have come across two problems. The first is that the install seems to fail for database services (and I see I'm not the only one), declaring the following: Thanks for the reply. The file permissions haven't been touched, and disk space certainly isnt an issue (doesn't even come close to filling any partition). I've dropped some more information into ...Show All

• Lats Move DTS packages from SQL 2000 to SQL 2005

  We have purchased a new Development SQL Server that is running SQL Server 2005. Our existing Development SQL Server is running SQL 2000. How can I move the DTS packages from the SQL 2000 server to the new SQL 2005 server I will be upgrading them to SSIS at some point, but don't have the time now. thanks sql server 2005 has a package migration wizard that might work for you. ...Show All

• PureCode Moving text file properties for sql2k dts to sql25k ssis packages???

  Hi everyone, We’ve got almost 250 old dts packages which simply loading data into Sql tables from plain files or at the reverse point. Most of them are defined with fixed fields and its fixed positions one after one. We don’t want to migrate them using Import wizard, on the contrary we’re producing them from the beggining taking advantatge of SSIS architecture to the full. And now, we’re trying to imagine how to migrate automatical ...Show All

• Vagolon Exporting to Excel from Preview Tab

  I designed a report and from Preview tab, i exported it to Excel format and saved. I sent the Xls file to others, but when they opened it, it is displaying the Metadata info of the file. any idea what is going on In my report i have a table, and above it i have a bunch of textboxes which serves as a heading for groups of columns in the table. when i preview it is fine. But Exported to excel, some of these textboxes are wrapping to the next line ...Show All

• Rob2001 SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• DLIRL Execution of Package failed

  I am trying to design package which would copy all tables and stored procedures from one server to another. It used to be simple task in SQL 2000, there was wizard. However the new wizard does not work... I wrote SSIS package, but when I execute I get the following error: "Can not apply value null to property Login..." Any idea It seems to me that this new SQl2005 is not that simple to use like 2000. 2000 was a great product. I am consider ...Show All