Viewing 15 posts - 46 through 60 (of 132 total)
SSAS will allow you to pick Gauge as the Indicator when you build the KPI in the cube. However, the issue becomes with the displaying of the KPI to the...
July 28, 2008 at 1:13 pm
as far as file size is concerned, i do not know of a limit but somebody else may be able to help answer that. i do not think you would...
July 28, 2008 at 12:13 pm
The options are endless here on how to perform this and you would not even need a script task, or need to code very little in the task.
In SSIS,...
July 28, 2008 at 9:42 am
i took a look around and came across this blog post that looks to be stating what it is you are trying to achieve:
http://lorentsnv.spaces.live.com/blog/cns!235C78448ABCFC07!178.entry
hth
July 25, 2008 at 12:36 pm
i am assuming that you have ssis as a tool to help build your requirement.
with that said, create a package that will have a data flow task
create a data...
July 25, 2008 at 12:24 pm
for future reference, if you go to BOL and filter to just the SQL Server Reporting Services Help, type in "Format Property" to look for and you will come to...
July 25, 2008 at 9:05 am
jack is correct in what he saying about the many rows being updated for a possible single record update. however, i wrote the trigger to handle the req, a single...
July 25, 2008 at 8:57 am
i would be wary of adding a trigger to a third party table in the event that they send you a change but the trigger is never dropped and therefore...
July 25, 2008 at 8:34 am
a couple of things I noticed in this view you are creating. the first being the error, it looks like you are creating this view in ORACLE, is that correct?
if...
July 25, 2008 at 7:22 am
when you create the Flat File source connection, you can state that the first row is a header record so that will remove the header row. (you can also state...
July 24, 2008 at 2:45 pm
Hari
One thought would be to create a reference table that had the table name and the last timestamp value for each table. When an update or insert occurs to the...
July 24, 2008 at 12:57 pm
Art
For the OLE DB Destination task, you cannot do updates, that task will only perform inserts into your destination table. The task that would do updates is the OLE DB...
July 24, 2008 at 12:22 pm
please post the code so people can take a look and offer suggestions.
thanks
July 24, 2008 at 12:00 pm
well, i would only use the query option if i was either pulling data from multiple tables in the same dataset or only selecting certain fields from the table to...
July 24, 2008 at 11:49 am
DDL triggers handle events when objects are modified in your database. Here is a quick excerpt from BOL:
DDL triggers, like regular triggers, fire stored procedures in response to an event....
July 24, 2008 at 11:43 am
Viewing 15 posts - 46 through 60 (of 132 total)