Problem when exporting data into Excel file from SSIS

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - Updating only changed fields Sorry Deborah. My mistake. You did mention locking early on and i didn't spot it. Now i have a better understanding of whats going on. I guess you could write the dynamic sql inside your stored procedure using sp_executesql that way leaving your code closer to the db layer. And I have read somewhere that query reuse is so much better these days that if you're smart with the way you do (parameterization etc) then you should get good performance. You could also add a datetime column and do a check on this when you send the update and if the last one is later then reject the update and refresh the screen (though i doubt the users would buy that). Or do some match up between the old values, the new values and the current values. This sounds horrible mind. Alternatively, I guess you could just stop people going for coffee ;-) HTH! Tag: Problem when exporting data into Excel file from SSIS
  - 2
    - Should i upgrade to SP2 ? I am using sql 2005 Enterprise with SP1. And its in a clustered environment. I am planning to apply SP2. I would like to know if there are any issues with SP2. i am lil cocerened if it will affect anything. Should i upgrad to SP2 Are there any issues esp. in clusered environment It wold be really helpful if someone can share his exp. Thanks Tag: Problem when exporting data into Excel file from SSIS
  - 3
    - Which SQL Server 2000 Edition should I install in at UAT environment Hi, We have a suite of applications which go through the full product life cycle and I was wondering which SQL Server edition should be installed in every each environment from Proof of Concept -> Dev -> -> UAT -> Systest... Production is straight forward but I am just not sure about all the other environments. thanks Lyn Tag: Problem when exporting data into Excel file from SSIS
  - 4
    - Error processing Cube - The syntax for ',' is incorrect. Hi guys! Could you help me with the next problem: Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Query (1, 10) Parser: The syntax for ',' is incorrect. I have installed sql2005 sp2, but didn't get much Pls. help Tag: Problem when exporting data into Excel file from SSIS
  - 5
    - Rerunning failed subscriptions We're using RS2005 SP1. One of our users has subscribed to a report to run the 15th of each month. This past July 15 was on a Sunday and our servers were down for backing up & maintenance. Since the servers were down, the job never ran and the user did not receive the report they were expecting Is there anyway to have jobs that failed to run because a server was down automatically run when the server comes back online Or perhaps have maintenance windows during which reports can not be scheduled to be run TIA -bruce Tag: Problem when exporting data into Excel file from SSIS
  - 6
    - SQL Server Data Migration and Synchronization To configure transactional replication all tables in your database have to have PK... If your one moth transaction log backup size is 114 GB, it will also includes database maintenance which will not be replicated when you use the replication means you may be replicating less data. To reduce the data replication you can replicate procedure executions...but I don't know it will work from 2000 to 2005. Replicating Stored Procedure Execution http://www.sql-server-performance.com/mak_replicating_sp_execution.asp If your client can efford 30-100 minutes down time, you can use log custom shipping, while moving log you can compress or you can use third party backup tools to compress them.. I did migration >.5TB from east to west coast using custom log shipping without any issues.. Tag: Problem when exporting data into Excel file from SSIS
  - 7
    - Different Font size when browsing and printing a report ? Hi all, Is it possible to setup different font size when a user is browsing or printing a report I have a lot of data to print on a report and i need tu use a font size of 7pt which is fine for printing but when the user is looking at the report on the browser a font size of 7pt is a bit too small and the bold doesn't work. Tia Tag: Problem when exporting data into Excel file from SSIS
  - 8
    - Analysis Services - Step by Step: Errors related to feature availability and configuration On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg: Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU. Is it because of my Standard Edition If it is, could I change the 'Measure expressions' some how to get by this msg and go on with the book Tag: Problem when exporting data into Excel file from SSIS
  - 9
    - SSIS Job Failed I did all the suggestions here.. but still it doesnt work for me i'm figuring this out the whole day. It works perfectly fine in the BI Development Studio. It work fine also when I import it under MSDB (File System as package location - right click Run package). When I put in on job... it failed... any other ideas The login account used by my SQL Agent is a member of the domain account . Tag: Problem when exporting data into Excel file from SSIS
  - 10
    - Creating a Mobile Application with SQL Server Compact Edition Hello!! I completed that example that I pasted in the subject part and when I try to synchronize my mobile database, the data from the server appear in my pocket pc; but when i refresh the data on my pocket pc they do not show on the server. Can anyone give me a hand thanks Tag: Problem when exporting data into Excel file from SSIS
  - 11
    - Use of a SSIS variable of type “Object” inside Script Component and Task Component In a Data Flow, I have the necessity to use a SSIS variable of type “Object” inside Script Component and assign to it the content of 'n' variables of string type. On exiting from the script the variable of type object should contain something like in the following lines: AAAAAAAAAAAAAAAAAAAAAAAAAAAAA BBBBBBBBBBBBBBBBBBBBBBBBBBBBB CCCCCCCCCCCCCCCCCCCCCCCCCCCCC DDDDDDDDDDDDDDDDDDDDDDDDDDDDD …………………. …………………. On exiting from the data flow I will use the variable of type Object in a Script Task, by reading each element in a cyclic fashion. Is there anyone who have experienced something like this Could anyone provide any example of that Thanks in advance! Tag: Problem when exporting data into Excel file from SSIS
  - 12
    - How to debug CLR SP using Visual Studio 2005? We know that automatic deplyment is currently broken. How does one debug the stored procedures in this case Thanks, Alexey Tag: Problem when exporting data into Excel file from SSIS
  - 13
    - reporting and monitoring Hey all I am new here and fairly new to SQL server. And yes i have a question, that maybe dumb. My boss wants me to reporting to him the health of the DB each week. So here are a few questions. 1. What really defines the "health" of a DB What elements should I be reporting to him 2. Is there any utilities out there that would be helpful or can SQL provide enough info 3. I am using 2005 standard, so I have the shipped reports in summary page. But is this enough and can I customize them Sorry I am having a hard time even asking the questions cause I am not really sure what to ask. Any help or pointing down t he correct path would be greatly appreciated. Thanks, jason and what about 3rd party utilities such as this>>>> Tag: Problem when exporting data into Excel file from SSIS
  - 14
    - SQL 2005 Query Analyzer I just installed SQL2005 Workgroup edition. How do I install Query Alayzer to go along with this Tag: Problem when exporting data into Excel file from SSIS
  - 15
    - "Can't find PInvoke DLL 'dbnetlib.dll'." every time when I opened the connection from my windows CE4.2 device to sql server I got the error "Can't find PInvoke DLL 'dbnetlib.dll'. My OS is MS CE4.2, I've installed Compact Framework 2.0 and SQL client. It worked fine at OS CE5.0 but not at CE4.2. My application is working correctly, but when I started the connection I received this error. Any idea thanks, Jan Tag: Problem when exporting data into Excel file from SSIS
  - 16
    - Number of reads in Profiler is not the same when running the same SP on different PCs Thanks for your help. It was problem with the execution plan. The SP was dynamic and was executed from the same connection without RECOMPILE option. Tag: Problem when exporting data into Excel file from SSIS
- Next
  - 1
    - adding a new data flow item calendar transformer Also, see the following thread on GACing Components... http://forums.microsoft.com/msdn/showpost.aspx postid=66049&siteid=1 Tag: Problem when exporting data into Excel file from SSIS
  - 2
    - Find and delete reversed key pairs. Thought so... I never used such construct (I mean, it depends on the context) before, though. Good to know. Tag: Problem when exporting data into Excel file from SSIS
  - 3
    - Can I create a database schema from a DataSet and/or .xsd file? I have some questions about creating SQL Server CE databases. Based on my experiments and what I've read on these forums, it looks like there are a couple ways to create a database schema. I can edit the database schema via the Server Explorer in Visual Studio, or use an external program like SQL Server Management Studio and somehow convert those files to .sdf files. I find Visual Studio's built in tools to be cumbersome to use and limited in functionality, and using SSMS seems like a roundabout way of approaching the problem. I understand Microsoft will be releasing better tools with Orcas, but in the meantime, I'm wondering if there are alternative ways to generate database schemas. For instance, I find Visual Studio's DataSet designer fairly easy to use. The DataSet designer generates schema definitions (.xsd files), and an instantiated DataSet can both read and write schema definitions via Read/WriteXMLSchema. Furthermore, DataAdapter's Fill and FillSchema methods can be used to push a schema from a database to a DataSet. So, can I somehow go the other direction and push a schema from a DataSet to a database It seems like all the tools are there... For example, if I create the DataSet schema, could I use a small app to create a new .sdf file, instantiate a DataSet, write the schema from the DataSet to the database, and then save the .sdf file Or given the generated .xsd file, is there any way to create a SQL database from that Thanks in advance for any replies. Tag: Problem when exporting data into Excel file from SSIS
  - 4
    - Can't reinstall sql server 2005 express Hi thanks for trying to help, but as you know I still can't seem to install it. At first I remove all SQL components on the ADD/REMOVE programs windows. I did not remove .net 2.0 framework or IIS from my computer as I need them for other programs. Then I restart the computer and install SQL Server 2005. It installed SQL native client, SQL setup files, SQL VSS writer, and then when it is trying to install SQL services it suddenly stopped and a messagebox appears saying "SQL service won't start please refer to online help". I tried installing like ten times and the same things happen. How can I install SQL server on my computer As for the error 26, I think I forgot to turn on the "remote access" from the system panel in control panel. Tag: Problem when exporting data into Excel file from SSIS
  - 5
    - How to protect my parameters Hello. I have a report with parameter called "parm1", that gets a value of "true" or "false" depanding on another parameter. When the report is runnig the parm1 value is "false". How can I protect this parameter from a change by the user I mean - the user can run the report and then add to the url "&param1 = true". Can I do anything against that I tried marking it as "internal" and I thought that now it can get his value only from inside the report but it didn't worked. Any ideas Thanks. Tag: Problem when exporting data into Excel file from SSIS
  - 6
    - Check to see if file exist on server did u resolve this and if so how did u do it Tag: Problem when exporting data into Excel file from SSIS
  - 7
    - error Are you using any UNION on your query.. Tag: Problem when exporting data into Excel file from SSIS
  - 8
    - Formating how to format an integer in sql 2005 for ex: 1.09876 i want to format to 1.1 in access i can use : format(field,'0.0') as field1 thanks Tag: Problem when exporting data into Excel file from SSIS
  - 9
    - sql cluster - fulltext error We have a sql server 2000 active/passive cluster running on Windows Server 2003 and within the last 6 months have started getting the following errors which eventually cause the SQL Resource Group to failover. An error occurred in the configuration monitor for instance <SQL Server Fulltext>: 80070005 - Access is denied . SQL is at the latest service pack/hotfixes. (8.00.2187) This cluster has been running fine for the past 3 years with no problems. Nothing has changed on the servers. We've had Symantic Antivirus running on the servers for a long time but the FTDATA folder and the sql data and transaction logs are excluded and nothing has changed on the configuration. We also run Diskeeper 2007 server on these servers but I can't see any problems with this. Once it fails over it will run fine for several days and then the same errors will occur and it fails over again. Any ideas on what might be causing this I can't really find anything on the Microsoft site that matches this error. Note: This has also just started happening on our test cluster which is an identical configuration. Tag: Problem when exporting data into Excel file from SSIS
  - 10
    - MSSQLServerOLAPService Stops MSSQLServerOLAPService Service seems to crash rather sporadically during our nightly ETL with the error of: The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured.. The time of the error in the event viewer seems to correspond with the step in the ETL that processes our AS 2005 database (Analysis Services Command Task). The job step reports success, and the data is refreshed so I don't understand why it is reporting an error in Event Viewer. The server is x86 with SQL 2005 sp2 installed. Has anyone else run across this Tag: Problem when exporting data into Excel file from SSIS
  - 11
    - How to Add Subscription or Subscribers manually through scripts instead of programming Hello everyone, I am new for SQL SERVER 2005 NS. I have gone through some samples about NS. Most of them add subscriptions and subscribers through vbs or .net application. So I got some questions to ask for your help: 1. I just wonder if there are some ways for me to add subscriptions and subscribers manually through T-SQL scripts instead of programming. Because sometimes, we don't need to ask our users to subscribe our message. 2. Is that possible for NS to send notification by SMTP without adding subscription For example, I have already populated all emails from database, what I need is just to send simple notes to these emails, and at this time, I don't need users to subscribe them. I just need to get NS works as database mail at this point - only send email notification without subscription. I am not sure if this is possible. ( I know with databse mail, this can be done easily, how about with SQL NS, any idea ) Would you please give me some advices I appreciate your help in advance. Best Regards, Tag: Problem when exporting data into Excel file from SSIS
  - 12
    - Retrieving a datetime with a time of midnight (from a typical datetime) Nothing difficult, I just need a way to generate a new datetime column based on the column [PostedDate], datetime. So basically I want to truncate the time. Thanks a lot. Tag: Problem when exporting data into Excel file from SSIS
  - 13
    - Reporting Services Date Format Problem Well I installed SP2 in a hope that it would fix it, initially on my development machine and was going to install it on my server today... glad you've saved me the trouble.. This seems to be a pretty fundamental problem with Reporting Services has no one else got a work around or solution Tag: Problem when exporting data into Excel file from SSIS
  - 14
    - Shared SSIS Staging/Dev environment We are in the process of setting up a shared staging/development enviroment in which multiple developers will deploy their packages for testing etc. The plan is to allow the developers to remote in to execute their packages, but we are worried about the concurrency limit of 2 users per terminal services. It is my understanding that you cannot execute packages remotely (ie you have to be on THAT box to kick it off. (FYI - we are not planning on using SQL Agent at this point - That will be with DBAs in UA) Please let me know what options are available/best practices... Thanks! Tag: Problem when exporting data into Excel file from SSIS
  - 15
    - Control Result of ExecuteScalar The user is calling a Stored Procedure with ExecuteScalar. When the SQL doesn't find a match, I'd like to return the results of a different SQL. For Example: If this doesn't find a match: select amount from Lookup Where application = @app Then I'd like to return: select amount from Lookup Where application = "DEFAULT" My actual situation is more complex than this. The first SQL is in a CASE statement. After my CASE is done, can I check the current ExecuteScalar return value Or someone determine how many records are in the last SQL to execute Also, ExecuteScalar always seems to get the 1st column of the 1st query. Can I have it get the 1st column from the 3rd query Tag: Problem when exporting data into Excel file from SSIS
  - 16
    - Remote Source and Destination Performance ~500,000 rows (depending on row size) should be extremely trivial to process. The timings of which should be under one minute, easily. I'm always amazed at the thought that 1,000,000 rows is a large amount of data. I'll put it into perspective: First Data Resources (one of the major credit card processing companies in the world) processes so many transactions per minute, that if 500,000 rows took over 10 minutes to run, they'd be out of business -- they'd never be able to catch up. With that said, the slow times are usually a factor of (and Jamie listed most of them already): network, local and remote hardware, row size, unique processing constraints (converting non-standard date formats to database date/time fields), whether or not you are logging each transaction, referential integrity checks, etc... Have you looked at the execution plan for your query to see if adding indexes or something might help Tag: Problem when exporting data into Excel file from SSIS

Sandra2006

I have problems when exporting data into Excel file from SSIS. It all works fine with numeric columns but an apostrophe is attached at the beginning of each text cell. I tried using derived columns and data conversions but it didn't work. It seems to me that problem is in 'excel destination' task... I saw many people had this kind of problems too... Is there any solution possible

Thanks.

Re: Problem when exporting data into Excel file from SSIS

HammerIP

I too am experiencing this problem. Have you discovered a solution

Re: Problem when exporting data into Excel file from SSIS

Phil Brammer

Export that data to a CSV file from Excel and you'll find that the tick does not exist. I believe you'll find that the 'tick' is just an Excel display feature. It's not really part of the data.

Re: Problem when exporting data into Excel file from SSIS

DouglasL

This inconvenient behavior of the Excel driver is mentioned in the BOL topic on the Excel Destination, and appears to be an attempt by the driver to force the output to be treated as string data (since the destination column does not really have a built-in data type), using the convention of the single quote that dates from Lotus 1-2-3.

-Doug