Search results for query: *

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...

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...

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...

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?

I am using a query in my OLE DB Source to pull a date and convert it into an integer smart date key in the format yyyymmdd. The code I am using as part of my query is case when svc.InstallDate is Null then Null else cast(convert(char(8), svc.InstallDate, 112) as int) end If I run the...

I am building a SSIS package to pull in and aggregate job cost data from our SQL Server OLTP system to our data warehouse. I have built a view on the OLTP server that will pull JobNumber, MtlQty, and MtlCost for each material item associated with the job. In the data warehouse, I just want to...

I have a fact table that I currently write about 1M records to as part of a nightly table load. I am using SSIS to pull the records over to my BI database as a staging table, which takes about 1 minute. I then run a stored procedure that copies the rows from the staging table into my final...

I have an SSIS package that I use to perform incremental inserts into a table. I want to modify the package so that it will do a historical load (i.e., will truncate the table and re-load the historical data). Is there a way to truncate the table within the Data Flow task just before I write...