Viewing 11 posts - 1 through 11 (of 11 total)
blom0344 (11/20/2012)
November 20, 2012 at 2:41 pm
The path in Explorer actually begins with http. It's easy enough to get: go to a document library, select Actions, then Open with Windows Explorer, and copy that address and...
February 25, 2011 at 8:52 am
Yes.
Create a variable type of "object" to hold the recordset for looping.
Create an Execute SQL Task that has a ResultSet property of "Full result set" configured
Add your select statement to...
February 24, 2011 at 11:42 am
A document library *should* be no different than a network share, except that you use an http address instead of a UNC address.
February 24, 2011 at 11:32 am
SKYBVI (2/10/2011)
yes the column is not unique but is a primary key..what should i do?
Regards,
Sushant
Primary keys must be unique. Use your ETL process to degenerate one. Identity columns make for...
February 10, 2011 at 8:27 am
Looks to me as if there are two fact tables: policies and transactions, both have agent relationships. The former is SCD. The latter probably isn't. Whether broker may or may...
February 9, 2011 at 2:46 pm
Yes, I just tested it with the query below. Other than warnings that I have no time dimension and that I *shouldn't* make a cube with only one dimension, it...
February 9, 2011 at 1:55 pm
Yes. Measures have a "DisplayFolder" property to which you can assign a text value. If the client application recognizes this property, this setting should give you want you want. Excel...
February 8, 2011 at 3:31 pm
OLE DB command is slow. If you have a significant number of updates or deletes, it will suffer in performance. I prefer to insert (fast) to staging tables, then perform...
February 8, 2011 at 8:17 am
I would try it without the four-part name. My queries against the AS/400 only used two part naming, but the data may have always been just on the IFS rather...
February 4, 2011 at 8:41 am
Viewing 11 posts - 1 through 11 (of 11 total)