Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X.
0
votes
1answer
176 views
Import batches of rows from Excel in parallel
We receive an Excel file weekly currently containing about 250k rows. The file grows by about 300 rows each week.
In SSIS I've hooked up an Excel source to an OLE DB destination to import the file ...
1
vote
0answers
100 views
How to aggregate calculated measures involving dimension attributes?
The business case is as follows -
I have a cube of sales transactions and a dimension of parts. One of the attributes of a part is the current cost, which is non-aggregatable. A user needs to model ...
1
vote
0answers
158 views
Update excel sheets from SQL Server 2005 linked servers
I use SQL Server linked servers to connect to Excel 2003 multiple tabs workbook. After connected, I have not problem to use select statement like:
select * FROM OPENQUERY(TEST, 'select * from [fist ...
0
votes
0answers
309 views
Using SSIS to download an attachment from Exchange/Outlook
I am recieving a weekly email that includes an attachment of an excel file. I'd rather not how to manually drop this email in a file location or manually update the data. I'd like to use SSIS to ...
0
votes
0answers
79 views
GUID for temporary table ADO
this is what I am trying to do.
Frontend: Excel
Backend: SQL server, or mySQl
In excel, I create an array, this array I want to pass into either a temporary cache table or into a new table in a ...
