Who is online?
0
guests and
1
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Excel
522 results found
SSAS Calculation Formatting Not Showing in
Excel
2007 or
Excel
2010
Occasionally in SQL Server 2005 and 2008 Analysis Services, you'll build a cacluation and set the formatting to be a value like a currency and are surprised that in Excel 2007 and 2010 the formatting does not carry over. The "randomness" of this actually
Author:
BrianKnight
Date: 10/1/2010 Section:
Blog
tags :
calculation
,
excel 2007
,
excel 2010
,
mdx
,
ssas
Remove the compatibility mode from excel files
As you all know Excel 2007 has lot more features compared to Excel 2003. The extension with which the excel files are saved alos differs based on the version of excel. For excel 2003 the file is saved as .xls and for Excel 2007 the file is saved as .xlsx
Author:
indupriya
Date: 3/2/2012 Section:
Blog
tags :
Compatibility Mode
,
Excel 2007
SSIS 2008 Using
Excel
in a Lookup Tansform
Learn how to use Excel in a lookup transform in a data flow in a data flow.
Author:
MikeDavis
Date: 12/6/2010 Section:
Article
tags :
Excel
,
Lookup
,
SSIS
Loop Through
Excel
File in SSIS
You can loop through excel files using SSIS. This will use the For Each Loop container and a Data Flow task. First create a variable named strExcelfile as a string variable; you can leave the value blank. Next, drag in a For Each Loop. Set the enumerator
Author:
MikeDavis
Date: 5/5/2010 Section:
Blog
tags :
Excel
,
Loop
,
SSIS
Dynamic
Excel
File
Hi I am facing the same problem.Created the simple package to load DimPorduct into Excel file from "Import and Export Wizard". I am not having any excel template or excel file. But when Irun the package it fails at first step (i.e. SQL task ) which is cre
Author:
faiz_bidn
Date: 2/9/2012 Section:
Forum
tags :
Dynamically Load Excel file
,
excel destination
,
Import and Export Wizard
Upgrade SQL/SSRS 2008R2 to 2012 SP1 SSRS
Excel
Rendering Issue
I'm testing upgrading SQL/SSRS from SQL 2008 R2 SP2 to SQL 2012 SP1 (11.0.3349). Most of my reports' data source is a Dynamics NAV 2009R2 SQL DB where most of the number fields are decimal(38,20). I'm finding that when I have a zero value in a column on a
Author:
tkruse
Date: 3/20/2013 Section:
Forum
tags :
excel 2010
,
render
,
SSRS 2012
,
upgrade
,
xml errors
Date Filtering in
Excel
from your Analysis Services Dimension
I recently had to set up another Date Dimension and went through the process of setting up all the properties in the date dimension so that when it is used in Excel, the end users would then be able to use the Date Filters built into Excel. The Excel Date
Author:
guavaq
Date: yesterday Section:
Blog
tags :
Excel
,
SQL Server Analysis Services
,
SSAS
,
ssis
Excel Web Access error in Sharepoint 2007
I wanted to use Excel Services on Sharepoint 2007 to migrate some of our BI reports from a third party application that we use. So I tried publishing to Excel Services from Excel 2007 assuming that our Sharepoint was setup to be used with Excel Services.
Author:
indupriya
Date: 2/16/2011 Section:
Blog
tags :
Excel Calculation Server
,
Excel Services
,
Excel Web Acccess
,
MOSS 2007
SSAS Reporting Actions with Date Parameters
Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want to pass in some parameters to the report so it shows the relevant data. If the parameter name matches the item in excel then this is a br
Author:
MikeDavis
Date: 4/22/2011 Section:
Blog
tags :
Action
,
Cube
,
Dilldown
,
Report
,
SSAS
,
Reporting action
,
SSRS
Updating a single
Excel
cell using SSIS
bsingha asked a question in the forums regarding how to update a single cell in one Excel sheet using the data from another sheet. So, I decided to post a quick blog post on how to accomplish this. First - make sure that SQL is installed and service packe
Author:
KeithHyer
Date: 1/16/2012 Section:
Blog
tags :
modify cell
,
VB.Net
Importing Into
Excel
Using Import/Export Wizard
The Excel destination is used to bring tabular data from a source to an excel spreadsheet. This can be a valueble resource for generating quick reports and data that can be easily manipulated by novice users. The problem is that moving data from OLE DB to
Author:
DanMatisis
Date: 7/16/2010 Section:
Blog
tags :
Excel Destination
,
Import/Export Wizard
Viewing Header / Footer Values in
Excel
after Exporting from SSRS
Today’s question in my SSRS class warrants a blog. The question was: “Why can’t I see my text box that I placed in my footer of my report, when I export the report to Excel?” Well, after much research today I realized that it was a
Author:
SMcDonald
Date: 8/24/2011 Section:
Blog
tags :
Export to Excel
,
Reporting Services 2008
Workbook is larger than the maximum workbook size
I use sharepoint 2010 to display the data analysis tool I have created in excel 2010 to manage the Microsoft licenses as well as to utilise the excel 2010 capabilities of slicers and dicers. This has been going pretty smoothly until yesterday when I stumb
Author:
indupriya
Date: 5/14/2012 Section:
Blog
tags :
excel web part
,
Excel web services
,
file size error
,
sharepoint2010 file size error
Setting
Excel
Connection Manager connection string dynamically
I have developed an SSIS package (using BIDS 2005) that requires almost everything to be set dynamically; Connections Managers, package variables, SQL statements executed by Execute SQL tasks etc. The reason for this is that the package is designed to be
Author:
lempster
Date: 11/27/2012 Section:
Forum
tags :
connection manager
,
Dynamic Connection Managers
,
Variables
Getting Started with Microsoft Data Explorer
What is Data Explorer Data Explorer simplifies the data discovery phase for Excel users that are creating self-service Business Intelligence solutions. It does this by provided straightforward methods for connecting to data previously unheard of, without
Author:
DevinKnight
Date: 3/6/2013 Section:
Blog
tags :
Data Explorer PowerPivot
,
Excel 2013
,
Power View
Excel Data Load Truncation Error
This article gives an explanation of and a solution to a truncation failure that can occur when loading from an excel data source. The engine that brings in the data will be examined and solutions will be laid out. There is a demonstration section that ca
Author:
DanMatisis
Date: 7/18/2010 Section:
Article
tags :
Data Load
,
Registry Keys
,
Truncation Error
,
TypeGuessRows
,
Excel Source
Export data from sql server to excel using SSIS???
Hello All, First I will explain what is my requirement and then I will explain what I have done so far and what are all the helps I need... I have to export data from sql server to excel sheet. The excel sheet will be like a standard template . If I run m
Author:
prabusuccess
Date: 9/28/2012 Section:
Forum
tags :
integration services
,
sql server
,
SSIS Error
Multiply and Divide a group of cells in
Excel
I just now realised that it has been more than a month since I have posted anything on my blog. So here I am with the most recent tip I learnt in Excel. If you have a column of cells that need to be divided by 1000 for example. Here are the steps that you
Author:
indupriya
Date: 12/4/2011 Section:
Blog
tags :
add
,
divide
,
Microsoft Excel
,
Multiply
,
Paste Special
,
subtract a group of cells.
Loading Duplicate rows from excel
Assuming that your Excel file has a column(s) value that is a unique key, you'd do it in a very similar manner to what you would for SQL server. Create an excel connection manager pointed to your excel file. Next, drop in your data flow task and within th
Author:
KeithHyer
Date: 6/22/2011 Section:
Forum
tags :
derived column
,
Excel Data Source
,
Excel
Importing
Excel
2007 data into SQL Server 2005
I had a requirement to import an excel 2007 spreadsheet into a database as a table in sql server 2005. In Excel 2007 the drivers required for exporting have changed when compared to the previous versions. With Excel 2007 you use the driver named 'Microsof
Author:
indupriya
Date: 5/13/2010 Section:
Blog
tags :
Sql server 2005
,
Excel 2007 import wizard
Dynamic
Excel
Sheet Creation ( expanded )
Edit: This is not new content. I've reposted this with corrected image links. In my previous blog post, I showed a row-by-row solution to creating an excel workbook dynamically using SSIS and populating one worksheet per row of data. Then "studio72" asked
Author:
KeithHyer
Date: 2/23/2012 Section:
Blog
tags :
Dynamic
,
Economy
Read a specific cell from
Excel
l and write in a specific cell in another defined excell cell in SSIS
Dear all, Recently i am working in SSIS for reading a specific cell from Excell and write into another Excell. But i can not find any help in the internet. Note: Read a specific cell from Excell and write into a specific cell in another defined excell cel
Author:
bsingha
Date: 1/14/2012 Section:
Forum
tags :
Excell Cell
,
Read
,
Write
what all are the possible chances for data from datasource is not copied into excel destination
Hi, Jobi. When you use Excel as a destination - you need to create a "table" in the excel spreadsheet destination into which the data can then populate. There is an example in my blog post here: http://www.bidn.com/blogs/KeithHyer/bidn-blog/2512/creating-
Author:
KeithHyer
Date: 1/17/2013 Section:
Forum
tags :
worksheet
Resolving #NUM error in excel
I was using excel to display data from a cube. I tried to do a caluclated cell in excel to display number of months between two dates. Here is the formula I used to do this. =Datedif(H1,G5,"m") But I received an error -- #NUM Then I again looked at the da
Author:
indupriya
Date: 2/22/2012 Section:
Blog
tags :
#NUM
,
#VALUE
,
Datedif in excel
Setting up an SSIS package with a dymanic
Excel
Source
Just the other day, we had a forum post here on BIDN that was asking how to set up an SSIS package with a dynamic Excel source. This source can be stored in a different file path or even with a different name on any given day. A solution for this scenario
Author:
kylewalker
Date: 8/24/2010 Section:
Blog
tags :
Excel Source
,
Package Variables
,
SSIS
Page 1 of 21 (522 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
...
Next >>
Go to page:
[Go]