Viewing 15 posts - 2,221 through 2,235 (of 7,164 total)
So what approach would you take? Would it be a script to mask the data post-restore? Or a table that is security-controlled with an overlayed view / proc...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 1:39 pm
PIVOT is nice but it's really just syntactical-sugar Microsoft added in SQL Server 2005 to implement a classic cross-tab query:
SELECT m.Movie,
MAX(CASE...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 1:13 pm
It sounds like a sketchy design because you want a proc to behave differently based in some implicit condition, namely who called it. Consider how you would unit test something...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 1:06 pm
What is the actual SQL operation? A series of inserts, updates or deletes? I single query? You never said.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 12:42 pm
Thank you for trying to provide a well-formed question. It looks like homework, which is fine, I am happy to help but I need a few things first:
1. DDL to...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 12:35 pm
Thank you for trying to provide a well-formed question. It looks like homework, which is fine, I am happy to help but I need a few things first:
1. DDL to...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 12:29 pm
You have some orphaned data that you'll need to cleanup before adding the constraint.
SELECT RIDER_NO
FROM TRIP_DETAILS
WHERE RIDER_NO NOT IN (SELECT RIDER_NO
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 12:26 pm
Which version of SSIS? Which Oracle driver?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 12:17 pm
The Excel Destination will simply append results. It sounds like you want to update other columns in the existing data. For that you would need to combine the two package's...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 12:16 pm
SQL_Kills (1/25/2013)
I get the following errors when running an ssis package, but tnot sure why this is, it is failure on a lookup table, any ideas?
Error: 0xC020901E at load all...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 12:11 pm
Never tried it but it's an XML file so could be edited. What are you trying to do?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 12:07 pm
If there are no transforms have you thought about setting up a Snapshot Replication Publication/Subscription to send data from SQL Server to Oracle?
If you must do this with SSIS then...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 12:05 pm
@crbnldy, if you provide some DDL so to create your tables, some DML so we can create some test data and the shape of the expected resultset I am confident...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 11:55 am
Bhuvnesh (1/26/2013)
why cant we use "xp_fixeddrive" ?
I suppose you could. I haven't used it since the SQL 2000 days and if what I am reading online is correct however it...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 11:50 am
anthony.green (1/22/2013)
Powershell will probably be the best bet on that
Get-WmiObject win32_logicaldisk | where-Object {$_.providername -like ''} | select deviceid, size
Win32_LogicalDisk will work in most cases but know that...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 8:49 am
Viewing 15 posts - 2,221 through 2,235 (of 7,164 total)