This site is a link to a much more helpful forum:
http://www.sqlmag.com/forums/messageview.cfm?catid=4&threadid=12288
It seems there will be a fix shortly available.
I have done some more testing. The DTS packages that have CSVs with > 37 columns work fine if I do not modify them.
If I modify them and click "Define Columns" Enterprise Manager shuts down.
Anyone else out there having trouble?
Hello,
I have a problem that I don't ever remember encountering before.
I have a text file that is comma separated like:
1,2,3,....37,38,39,40
1,2,3,....37,38,39,40
etc.
I use a Text File Source connection and point it to the file. I make a Text File Destination connection and point it to a...
Ok, I tried something like this:
IIF(IsLeaf([Inv_Time]),sum({[Inv_Time]},[Measures].[Inv Value]),IIF(IsGeneration([Inv_Time],1),sum({[Inv_Time].lastchild},[Measures].[Inv Value]),sum({[Inv_Time].lastchild.lastchild},[Measures].[Inv Value])))
It uses Inv Value instead of Qty, but it is the same...
Scenario:
I have the measures Sales and QtyOnhand for items by month.
When I view the data for June, I see total sales for the items through June, which is perfect.
However, I also see the QtyOnHand is aggregated for all the items (which is great) and for all the months through June (which is...
I have a questions about calculated members.
All the examples I see do a simple calculation like GM :
[Measures].[Sales] - [Measures].Cost]
What I want is inventory value, like:
[Measures].[QtyOnHand] * [Measures].[AvgCost]
What happens though is that the operations are done in an order that...
I have 4 regions: West, Mid-west, East, and South.
I have 3 warehouses in each region.
Currently, I have 1 dimension with the levels Region and Warehouse. The problem is that when looking through the data I always have to drill through the region level to look at a warehouse. And when I use...
I have done ASP programming before using ADOand also made extensive use of ADO in Excel and Access. I have also done some T-SQL as well as a good bit of VBScripting using ADO in SQL Packages.
So are those really the only ways to go if we develop a program in house (using ADO on web pages, in...
Hello. We are using an ERP system with a poor budgeting module. I am to decide how to best overcome it, but have hit a road block. Background:
The ERP system runs a daily routine to updates the data warehouse run on SQL Server.
On that same SQL Sever (for now anyway), we plan to have a DB...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.