Modifying Existing Rendering Formats

Aug 22, 2007

Good morning (afternoon/evening) all.

I am researching a way to render data in a plain text file, with no formatting.

I plan on building out the result set to exactly what I am wanting and just need it to render itself without any formatting logic being taken into consideration.

The end result is to generate a QIF file from a random data set. QIF is just a formatted text file.

Am I making sense?

Any help would be greatly appreciated.

View 2 Replies

Modifying Already Existing DTS Package

May 23, 2008

HI Gurus,

I am tring to add table to alraedy existing DTS pacakge to refresh data from other server.

I dragged items from tool list (SQL SERVER Entripice manager)

Ther ia m not able to connect those two icons(one source and other destination).

How can i proced to next step.

Thanks,
ServerTeam

View 3 Replies View Related

Modifying Existing Data

Nov 24, 2005

Hi Guys,

I am new to sql server 2000, and need a little help.

I have a table called CMRC_Products with various columns, there is one column called Product Images that has the name of every image in my catalog over 4000, I want to add to each row in that particular column .jpg without loosing what is already in there

I have tried:

UPDATE CMRC_Products
SET ProductImage = ProductImage&' .jpg'

But I get an error,

any help would be much appreciated, cheers

View 1 Replies View Related

Modifying Existing Table Schemas?

Jul 28, 2006

By default, I constructed my database using the dbo Schema. I have since created new Schemas, and want to change some of the tables from dbo.

Is there a way to change the existing schema of a table without disrupting the data that is inside the table?

For example:

Current: dbo.Products

Desired Change: NewSchemaName.Products

Thanks.

View 4 Replies View Related

Integration Services :: Error When Modifying Existing DTSX Package

May 12, 2015

We are struggling to add an extra column to a Dtsx package. The package essentially compiles data into a table and then exports the data to a series of Spreadsheets. So far I have ended up doing the following: -

-Creating a new Folder for the Spreadsheet Templates, copying the existing spreadsheets into the new Folder and then added the new Column.
-Creating new Connection Managers in the Package to connect to these new templates.
-Adding the column to the various data flow tasks so that the new column is converted and then exported (data type is varchar(30), conversion type is Unicode text stream [DTNTEXT]).

Everything validates when we compile the dtx package. However when we run the package we are getting the following error: -

Started: 5:39:49 PM
Error: 2015-05-12 17:45:39.05
   Code: 0xC0202009
   Source: Data Flow Task Voluntary Excel [2379]
   Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
End Error

[Code] ....

View 5 Replies View Related

Either Rendering Tiff Images In SRS Report Viewer Or Converting Tiff To Jpg Or Gif And Then Rendering

Jun 19, 2007

First of all, this is not in reference to using SRS (SQL Reporting Services) to render a report and then use one of the extensions to render the complete report as a pdf, tiff, excel etc. We have an opportunity to render a list of claims and then embed the supporting docs for each of the claims within the report. We don't have an issue referencing jpg and gif images via URLs and then rendering them within the report after the grid information. We do have an issue rendering tiff images within the report.

You can insert an image object into SRS at design time and have it render and you can convert a complete report to a tiff image but I cannot find a way to be able to render a tiff image when running the report. All you get is the red "x".

My question is has anyone encountered the same issue and, if so, what did you do to resolve the issue?

Thank you,

J Z

View 3 Replies View Related

How Can You View The Connection String Of An Existing Datasource? How Do You Delete Existing Dataset?

Nov 14, 2007

I went to look at the connection string previously entered for a dataset created in a new report, and am not seeing anything intuitive for bringing up the associated datasource dialog box that was used to enter name, type and connection string. I'm also noticing nothing intuitive for deleting an existing dataset. How do you do these two very simple things in an existing project? I dont see the dataset in solution explorer, I see it only in the text box on the data tab and in a limited kind of way on the dataset view where the columns show and maint is allowed mostly on the columns only. I tried hilighting the dataset here and hitting the delete key to no avail.

View 1 Replies View Related

Force To Close Existing Connections When Restoring Existing Database

Aug 13, 2007

Hi All,

I would like to restore database using RESTORE DATABASE ... REPLACE command.
If database exists already and has any open connections this command will fail.
I would like to close all existing connections to specific database before running RESTORE DATABASE ... REPLACE command.
I can do closing from Management Studio using checkbox "Close Existing Connection" when deleting database. Actually I need to do the same but from script.

Please advice me how to do it.

Thanks in advance,
Roman

View 3 Replies View Related

Date Formats...UK

Oct 9, 2001

My SQL 7.0 database is set to show UK format date ranges. But when opening a table and adding criteria to the grid pane I having to put the US format date to retrive correct results...

Is this correct. I am wanting to be aboe to enter UK format in the criteria

Thanks...Scott

View 2 Replies View Related

Date Formats In SQL 7

Jan 23, 2001

Hi,

I am creating a VB application that will run on a NT machine with Regional Settings as UK English and dd/mm/yyyy settings. When I try to input these values into SQL 7.0 ( default database setting mdy and us_english with Regional Settings as UK dd/mm/yyyy) , I get the error -" The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value " .
Can I change my databse to always be dmy format. It seems to be active for a connection , can it be configured somewhere .

Any help will be greatly appreciated !

Regards

Anand

View 3 Replies View Related

Changing Formats

Apr 25, 2007

Hey guys,
I have a file that has date formatted like so: 2006-11-16 20:12:00
I would like the dateformat to be like mm/dd/yyy hh:mm

The file is being pulled into a varchar field..... as 2006-11-16 20:12:00
when I do a conversion i can only get it to mon 11,2006

any suggestions

View 1 Replies View Related

Date Formats

Dec 4, 2006

I read this and got confused...I use PHP and got this:$sql = "delete from blabla where startdate< =to_date('2000.05.05','YYYY-MM-DD')";$result=odbc_exec($conn, $sql);Result: Warning: odbc_exec() [function.odbc-exec]: SQL error:[Microsoft][ODBC SQL Server Driver][SQL Server]'to_date' is not arecognized function name.to_date should work?At the other end i'd like to read out startdate as a date var or formatit as I need.... (dd.mm.yyyy). Convert makes me confused... helpplease?S

View 3 Replies View Related

Q. About Binary Formats.

Jul 20, 2005

Is it true that binary and varbinary has a max-kapacity at 8000 bytes? Imjyst unsure how to read the dokumentation and want to be completely sure.And image is only one to use for data aobve that size?Thx in regards for clearing things out for meReagardsAnders

View 1 Replies View Related

SSRS Formats

May 1, 2008

Hi,

I have two beginner questions:
1. How should I set up report layout/printing format so it would fit to the page?
2. Is there a way to change the color of every other row in the table? Can I highlight the rows based on some kind of a condition?
Thank you.

View 4 Replies View Related

Time Formats

Mar 7, 2007

OK - totally new to this game but here goes ...

I want to put together a database to record times achieved by swimmers in competition. The database itself is simple but I don't know what format to use to store the time achieved. Times can vary, for example 35.27 (SS.00), 1.12.63 (MM.SS.00). Oh, and by the way I want to rank the output but haven't even begun to think about that yet!

View 3 Replies View Related

SQE Vs. SQL 2005 .mdf Formats?

Sep 4, 2006

Hi,

My ISP says that the file format for SQE .mdf files is different than a regular sql2005 .mdf file. So, what I am told to do is backup my SQE file, and send it to them to restore into a SQL2005 format.

Does that make sense? Or should I simply be able to upload a .mdf file to their SQL2005 server without backing it up for them to restore?

Thanks,

-JS

View 6 Replies View Related

Different Datetime Formats

Sep 25, 2006

Hello..

I have a problem with DateTime...In my local sql server I use "mm.dd.yyyy" format and i work fine with the database. But that crashed in my clients sql server. Their sql server wants "dd.mm.yyyy" format. Ofcourse I can use parameterized queries and solve the problem but I write the program on WinCE5.0 and I use the RDA method to access the SQL Server.In RDA,I have no chance to use parameterized queries as I know.

How can I solve the problem and what causes this problem? A setting in sql server or something else?What causes this difference..?

I wish I could explained my problem..

Thanks in advance.

View 4 Replies View Related

Calculations And Formats In SRS

Nov 2, 2007

Hi--

I am relatively new to SQL Reporting Services and have a couple basic questions (I think they are basic).

First, lets say that I have the following fields in the body of my report: Sales, Cost, Profit, and Percent Profit. Percent Profit is a calculated field of profit/sales.

Then, I have a grouping by customer, with a footer with the sum of sales, sum of cost, sum of profit. And I also want percent profit, but I do not want a sum or average of percent profit. Instead I want percent profit calculated as sum of profit/sum of sales. I cannot seem to get this to work with a calculated field. I must have the syntax wrong (as I was just taking sum(fields!profit.value)/sum(fields!sales.value)*100.

Also, I understand the format of #,# can be used to print a blank instead of zero. But this format also suppresses any decimals. So if I have a field that needs two decimals when there is a value, but need it to be blank when 0.00 is returned, what is the appropriate format?

Any help that can be provided would be much appreciated. As books are great, but sometimes do not explain everything. Thanks!
-Christina

View 8 Replies View Related

Time Formats

Mar 7, 2007

View 5 Replies View Related

Converting Date Formats

Apr 10, 2000

Hi,

I need to convert the output of a query

From:
Sep 13 1999 12:00AM

To:

1999-09-13 00:00:00.000

I need it to be in 7.0 format)

Thanks.

View 1 Replies View Related

Good Ol` Date Formats And BCP

Oct 26, 1998

Hey all,
I`m trying to BCP in some data from a csv file. It has dates formatted like d/mm/yy and when run BCP it errors. Of course...SQL language is set to English(United States) so it wants it in mm/dd/yy. But from what I`ve read in the archive, from Sharon at least, is that only in BCP will it use the NT date setting which for me is English(Australian) or d/mm/yy. So I`m thinking, `that`s ok` my data`s dates like d/mm/yy and nt dates like d/mm/yy it`ll bcp in fine - but no.

What can I do? I cant change my sql setting and I cant change the way I dump my dates to the csv! Suggestions......

TY
Simon

View 2 Replies View Related

Conversion Between Date Formats

Jul 23, 2005

Hi. I have a DB in which we store dates in yyyy/mm/dd. However when wewant to display this date via a web frontend, it needs to be indd/mm/yyyy. I've declared a function (shown below) which convertsbetween these date formats and returns a varchar(20). This works finehowever now I need to have the ability to sort on this date field inthe frontend. This requires my function to return a datetime in therequired format. Can this be done?DECLARE @InputDate nvarchar(20)DECLARE @OutputDate nvarchar(20)DECLARE @Day nvarchar(2)DECLARE @Month nvarchar(2)DECLARE @Year nvarchar(4)DECLARE @Time nvarchar(12)SET @InputDate = '2005/03/01 14:30:00'SET @Day = cast(datepart(day,@InputDate) as nvarchar(2))SET @Month = cast(datepart(month,@InputDate) as nvarchar(2))SET @Year = cast(datepart(year,@InputDate) as nvarchar(4))SET @Time = substring(cast(@InputDate as nvarchar(23)),12,12)SET @OutputDate = replicate('0',2-len(@Day)) + @Day + '/' +replicate('0',2-len(@Month)) + @Month + '/' +@Year + ' ' + @TimeSELECT @OutputDate AS OutputDateThxVilen

View 1 Replies View Related

Outher Joins Formats

Jul 20, 2005

HiI work ith sql server 2000 and i need know the diferentof joins in format not ansi ( with * ) and joins in formatansi ( with 'outher join on' ).Two format work equal ???What is de correct format ???Thank you.R.

View 2 Replies View Related

Changind Date Formats

Jul 20, 2005

Hi.I had a VB program that was using an SQL Server 6.5 DB. Date formatwas dd/mm/yyyy. Now the DB was changed to an SQL Server 7 and the dateformat is yyyy/mm/dd.How can I do for changing date formats in the new DB to the oldformat?I�m searching for a database level solution, not server level.thanks

View 1 Replies View Related

Character Field Formats

Jul 20, 2005

I was wondering what everyone felt about the fomats in characterfields where the front end application accepts anything.I wouldn't want a customer table where the customer name was lowercase on one, upper on another and who knows on the third.If character fields are not consistent, then formatting will have tohappen every time someone access the data for reporting - as anexample ...Thanks,Craig

View 1 Replies View Related

Dreaded SQL Date Formats (UK/US)

Jan 18, 2008

Hi Folks

I have a SQL date problem that I just cant get to the bottom of.
A SSIS package runs that inserts dates into a SQL table from strings in the format dd/mm/yyyy
This package is run from within a SQL job.
Unfortunately the dates are being interpreted as mm/dd/yyyy. I have checked every possible date setting that I can, but nothing seems to work (SQL Agent account lang is set to British English, collations, Locale ID setting in the SSIS package, Lang of account that runs the SSIS service).

When the package is run in BIDS it inserts the dates correctly, just not from a SQL job.
I have tried inserting SET DATEFORMAT dmy in an Execute SQL Task in the SSIS package but that does not work either.

The baffling thing is that it works on one server but not another. Both servers have the same collation, regional settings and use the same SQL Agent account.

Also when SELECT @@Language is used is this determined by the lang setting against the user ?

Any help would be appreciated. Thanks in advance.

View 3 Replies View Related

Date Formats In SSIS

Dec 1, 2006

Hi once again guys,

I seem to be struggling with everything in SSIS these days!

I have a datetime field and I want to convert it to the following format in my derived column component :

yyyy.mm.dd

I also have another datetime field but this time I am only interested in the time values and I want to get :

HH:MM

How do I go about doing this in the SSIS expression builder?

Please help.

View 14 Replies View Related

Send Report With 2 Or More Formats

Dec 14, 2007

Is there a way to send a report with 2 or more formats? Let's say a customer wants a report in both PDF and Excel format in the same email. Is this possible?

Thanks,
Stuart Fox

View 3 Replies View Related

Disabling Export Formats

Apr 2, 2008

I'm currently using SQL Server 2000 and SSRS 2000 with the latest Service Packs.

I need to disable Excel Exports for a single report.

I've found a way to disable Exporting Formats but it disables for ALL REPORTS on the server.
This involves changing the rsreportserver.config file.
http://blogs.digineer.com/blogs/jasons/archive/2006/05/10/93.aspx

Another site mentions a way to disable Exporting Formats for a single Report.
http://mikemason.ca/2007/04/30/

Code Snippetusing System.Reflection;
using Microsoft.Reporting.WebForms;
using Microsoft.SqlServer.ReportingServices2005.Execution;

namespace MyProject
{
public class ServerReportDecorator
{
private readonly ServerReport serverReport;

public ServerReportDecorator(ReportViewer reportViewer)
{
this.serverReport = reportViewer.ServerReport;
}

public ServerReportDecorator(ServerReport serverReport)
{
this.serverReport = serverReport;
}

public void DisableUnwantedExportFormats()
{
foreach(RenderingExtension extension in serverReport.ListRenderingExtensions())
{
if(extension.Name == "XML" || extension.Name == "IMAGE"
|| extension.Name == "MHTML")
ReflectivelySetVisibilityFalse(extension);
}
}

private void ReflectivelySetVisibilityFalse(RenderingExtension extension)
{
FieldInfo info = extension.GetType().GetField("m_serverExtension",
BindingFlags.NonPublic
| BindingFlags.Instance);
if (info != null)
{
Extension rsExtension = info.GetValue(extension) as Extension;
if(rsExtension != null)
{
rsExtension.Visible = false;
}
}
}
}
}

I'm looking for further clarification of this process.
1. Where I can download the Microsoft.SqlServer.ReportingServices2000 dll?
2. Does anyone have a project example of the process? How/When to actually use the code quoted?

View 2 Replies View Related

Changing Date Formats

Dec 23, 2005

Hello. I am using Microsoft SQL Server Management Studio (SQL Server 2005). When I select a date column from a table, the date is displayed in "mm/dd/yyyy hh:mm:ss" format. Is there a way i can change this date format so that it shows "dd/mm/yyyy hh:mm:ss" permanently? Thanks.

View 3 Replies View Related

Converting Datetime Formats And Layouts?

Apr 30, 2007

Opening DimTime table of AdventureWorksDW sample database in MS SQL Server Management Studio shows me values in FullDateAlternatKey like

View 3 Replies View Related

Problem With Money And Datetime Formats

Sep 29, 2005

I am getting the result in the format shown below but i want the Min Salary and Max Salary to be just 32000 and 40000 respectively. And can change my JobDate to normal 26/09/05 format. I know that convert(char(12), column name , 103) has to be used but its not working out for my sql code.Thanks in Advance @list nvarchar(200), @minsal money, @lbtime int, @Sortby int, @a intSELECT J.* FROM JobDetails AS J JOIN ( SELECT DISTINCT J1.JobID FROM JobDetails AS J1 inner join dbo.Split1(@list, ' ') AS S ON J1.JobPosition LIKE '%' + S.Data + '%' AND (@lbtime = '0' OR MinSalary <= @sal AND @sal<= Maxsalary) AND (@a IS NULL OR (J1.JobDate BETWEEN DATEADD(ww,-@a-1,getdate()) AND GETDATE() ) ) ) J1 ON J1.JobID = J.JobID ORDER BY CASE WHEN @SortOptions2=1 then JobPosition End,CASE WHEN @SortOptions2=3 then MinSalary END,CASE WHEN @SortOptions2=4 then JobDate END DESCJobID JobPostion Min Salary Max Salary JobDate6 SAP HR Manager 32000.0000 40000.0000 2005-09-26 00:00:00.000

View 4 Replies View Related

How To Convert Hexadecimal File Formats?

May 19, 2000

Dear SQL folks,

We have files from an event log in a DEC Alpha server and we would like to create a database program to import these files and then be able to read and query the info in them.

These files contain information such as error codes about the machine that the Alpha controls. They also contain time stamps. I am told that these files are hexidecimal.

Someone mentioned in passing that if we use MSaccess as the database, we would first have to write a program to convert these files to a format that Access can understand.
But, we were told that SQL7 has Add-ins that comes on the CD that can convert these files to a format that SQL7 can then understand.

Does anyone know if this is true..and how difficult is file conversion to accomplish?

If anyone thinks that they might be able to help us, I can sent them a small sample of the hex files
Thank you in advance

View 1 Replies View Related