Answer Questions

• sandeepkumar puppala Convert UTC time to local time

  Hello, I am new with the reporting services. I am creating a report and I need to display date/time on the report. But the servers stores those date/time in UTC. How can I convert them to the local time in my report.   Thanks for your help.     This works for conversion based on the time zone of the report server, but not the client. Is that correct I tested this by using the fun ...Show All

• Shady-Potter Loop through each record and then each field within each record

  I need to essentially do 2 loops.  One loops through each record and then inside each record row, I want to perform an insert on each column. Something like this maybe using a cursor or something else: For each record in my table (I'll just use the cursor)      For each column in current record for cursor               perform some sql based on the current column value      Ne ...Show All

• cehagema SSIS Doubts

  I am having this question in my mind from when I started using SSIS.. In a package I have an OleDB source and a flat file destination. and I hook up the source to destination in SSIS and run the package.. it works .. fine.. but internally what is done does SSIS performs BCP out But, bulk insert task is already there in BIDS then whats the difference of using this way Going ...Show All

• bungalo101 SSRS 2000 with VS 2005? Report Designer

  We have SQL Server 2000, and SQL Reporting Services 2000. In order to design reports I just purchased (and installed) Visual Studio 2005, but can't get the Report Designer to install from the SSRS 2000 cd. It gives me a warning stating I don't have VS 2003 installed. All the marketing blurbs about SSRS 2000 say that you need VS 2003 or later in order to get the report designer. How do I make this work Thanks. ...Show All

• Andrei Faber Importing unicode data from Oracle Database

  Hi everybody, i try to import data from an oracle database configured in unicode. When i run the package i have an error message Error at Data Flow Task [Source - ACCOUNT]: Column "ACCOUNT_CODE" cannot convert between unicode and non-unicode string data types. how can i resolve this regards. Open up your package and set the data type of ACCOUNT_CODE field to be DT_WSTR. -Jamie The Oracle CharacterSet is ...Show All

• 5-HT DM Windows Forms Controls in November Feature Pack for SS2005

  Hello, There is a download in the Feature Pack For Microsoft SQL Server 2005 - November 2005 for the Microsoft SQL Server 2005 Datamining Viewer Controls. Unfortunately I cannot find a shred of documentation for said controls. It would be nice to know what their names are, where they are installed, how you add them to your toolbox. Sample apps would be of great benefit as well (but I don't want to ask for too much). Here is the descriptio ...Show All

• Derek Lakin Two Instances (SQLEXPRESS and MSSQLSERVER)

  Hi there, I installed SQL Server Express few days ago but today I coudn't start the Management Studio. After reinstall the management studio, the problem stay. Then I uninstall SQL Server, but I still had acess to the configuration manager and I see that the instance SQLEXPRESS still runing, even with all unistalled (SQL Server, Management Studio, Framework 2.0, Visual Studio). Then I install again Sql Server, and it detected that the default In ...Show All

• Paulson XQuery/XPath and element substition

  Does anyone know how XQuery/XPath would work with element substition For example, if a schema had a /customer/name element, and a substitution of /kunde/navn, would looking for /customer/name find documents with either of /customer/name or kunde/navn e.g. schema fragment: <xs:element name="name" type="xs:string"/> <xs:element name="navn" substitutionGroup="name"/> <xs:complexType name="custinfo">   <xs:sequence> & ...Show All

• caesar2k Indirect configurations ROCK!

  Hi Jamie, You wrote In your blog which I pasted below: "I have built my packages in such a way that different packages can use the same configuration file. For example I have a "Master" configuration file that stores information that all of my packages will need (e.g. connection strings for my log files, warehouse database and metadata database). Our project makes use of many source systems so I also have a configuration fi ...Show All

• DuncanP - MSFT Dynamicly load tables for DataSources/DataDestinations

  Hi everybody, The names of the tables that sould be transfered from the production system to the DWH are stored in a table in the production system. Yet I haven't found a proper way to dynamicly define these tables as DataSources and DataDestinations within an Integration Services project. I hope somebody can help me. Thanks. Is the metadata of these tables the same If so you could loop over the list of ...Show All

• Rburkhal Viewing the report as it is being generated?

  Is it possible for the first page to be viewed while the rest of the report is still being generated on the server or does the entire report need to be generated on the server before the first page can even be viewed I understand that for downloading/exporting the entire report would need to be generated before that functionality would work but what about just viewing the report as it is generated. Thanks Scott ...Show All

• JohnsonInBeijing Unable to retrieve Column information when using Ole Db Provider for sybase

  Hi All, I am in process of transfering data from Sybase to Sql Server using SSIS 2005 have taken a Data Flow Task in Control Flow tab In Data flow tab, I have taken one Ole DB Source and One OLe DB Destination For the source, I am using Sybase Adaptive Server Anywhere Provider 8.0 For Destination, I am using Sql Server 2005 database In Ole Db Source Editor , For OLe Db Connection Manager, I choose Sybase Connection For Data ...Show All

• renis Package Validation Error + Code 0xC004801C

  Hi, I am learning to use SSIS for creating packages. I am getting the following error when I try to execute my package... Package Validation Error Error at Data Flow Task[DTS. Pipeline]:The "runtime connection "FlatFileConnection "(122)" in the connection manager collection, Connections, of component "Flat File Destination ("120") does not have a value for the ID property. Verify that the Connect ...Show All

• mduffin Combine Data and Split into separate txt files for each header/detail row groupings

  I’ve created with the help of some great people an SSIS 2005 package which does the follow so far:   1)        Takes an incoming txt file.   Example txt file: http://www.webfound.net/split.txt       The txt file going from top to bottom is sort of grouped like this      Header Row (designated by ‘HD’)       & ...Show All

• vivekr External documentation

  I know that the BI studio can build a nice flow document that is associated with the package.  Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio Mark E. Johnson    KirkHaselden wrote: We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time ...Show All