Search results for query: *

You would need to deploy the SSIS package to the appropriate server. Then you could schedule a job through Management Studio and set the Type as SQL Server Integration Services Package.

If I understand your question correctly, you could do it either way. Do you have to do any transformations or cleansing of the data as you shift it from one db to the other? If so, SSIS might be your better choice because it is usually faster to do those transforms in the data stream...

Yes, and I do use those to look at report usage and other metrics. However, I don't see anywhere that I can load and pull free-form data that we would enter for additional info on individual reports, like recording the user(s) who can authorize changes to the report. I guess what I'm looking...

I'm trying to access and store metadata for our new Reporting Services installation, and I had a couple of questinos: 1. Is there any place in the report design to store information about the report that might then be queried. I can see where I can enter an Author and Description, but I'd like...

Never mind. I found the "feature" where padded varchar() strings will not match with a CacheType of Full, but will match with Partial or None. I added some Derived Column transforms to trim the columns in the two tables as I import them, and it seems to be working. I guess if it weren't for...

I pull data from a SQL table that has a column that can be 7 - 9 characters long which has a varchar(9) data type. I pass that column into a Lookup transform where the lookup is done against another table with a varchar(9). My problem is that the Lookup seems to be throwing an error on any...

Try buiding your SSRS report using the Wizard. It will provide a view of your cube similar to the cube's Browser window. If you put dates in the parameter fields up top and check the Parameter check box, it will auto generate the MDX that you need.

I have a cube that tracks sales by sales rep. In this cube, I have dimensions for SalesRep, Product, and Region hierarchies. I also have a Time dimension that provides Fiscal Year, Fiscal Quarter, Fiscal Month, and Calendar Date; the Time dimension also has an attribute showing the first day...

How do you derive the column that has NULLS?

Do you use any reporting software like MS Reporting Services or Business Objects? Most reporting front-ends will allow you to schedule e-mailed reports in a variety of formats, such as Excel or PDF.

What's your data source? I'm thinking the easiest way would be to do the calculation in your proc or cube.

One thought off the top of my head: Set up a pair of cascading parameters. The first parameter would allow the user to type three characters. The second parameter would be the query that generates your list, but it would now accept the first parameter and include a WHERE clause like: WHERE...

Taking SQLSister's reply one step further, it really does depend on how the data is loaded. The table containing the data loaded first needs to be your primary table; it should be FK'd to the table with data loaded after. Otherwise, you could get a key violation.

We are just moving from an environment where we ran all our reporting against the OLTP database (requiring virtually no ETL), to an environment where we are reporting against a dimensionally modelled data warehouse. We are using SSIS as our tool for loading the data warehouse, and my entire...

I would love to be able to copy and print the Control Flow diagram from an SSIS pacage for presentation and to insert in some project documentation. When I do a File > Print from VS it breaks it into multiple pages; don't see any way to copy it to Word or Visio. Anyone have any ideas?

Ooops, forgot the commas: select Month(DateAdd(mm,-6,getdate())), Month(DateAdd(mm,-5,getdate())), Month(DateAdd(mm,-4,getdate())), Month(DateAdd(mm,-3,getdate())), Month(DateAdd(mm,-2,getdate())), Month(DateAdd(mm,-1,getdate()))

I think you want to use DateAdd instead of DateDiff: select Month(DateAdd(mm,-6,getdate())) Month(DateAdd(mm,-5,getdate())) Month(DateAdd(mm,-4,getdate())) Month(DateAdd(mm,-3,getdate())) Month(DateAdd(mm,-2,getdate())) Month(DateAdd(mm,-1,getdate())) I suppose if you want...

OK - If I understand correctly, you have a ClaimTransaction Fact table that is FK'd to a Claim Dimension, and you have a Repair Fact table that is FK'd to a Repair Dimension and to the Claim Dimension. You have a Repair Date in the Repair Fact table that you want to include in the...

Remember - float and real are approximate data types. This means that they don't always store the exact number. For example, 12.0099 might be stored as 12.01. If you need the numbers for precise calculations, you should use numeric. Otherwise, I think float requires slightly less storage...

Are you loading the tables in sequence, or in parallel?