Viewing 15 posts - 11,416 through 11,430 (of 13,859 total)
I think the OP merely wants a script which lists permissions, rather than sets them, though it's not the clearest post of the day 🙂
May 9, 2011 at 1:55 pm
The system is defaulting to integer arithmetic.
Try dividing by 1024.0 to force real precision.
May 5, 2011 at 10:25 am
kaps.manshani (5/5/2011)
Uripedes Pants (5/4/2011)
May 5, 2011 at 7:39 am
SKYBVI (5/4/2011)
Koen Verbeeck (5/4/2011)
So you have data in one table, you want to manipulate it with TSQL and put the results in another table.I would use an Execute SQL Task.
Why...
May 4, 2011 at 9:12 am
That's going to be slow if there are a lot of records, but a loop will work well enough.
Have you thought about modifying the software which is displaying the link...
May 4, 2011 at 6:28 am
parthi-1705 (5/4/2011)
Phil Parkin (5/4/2011)
parthi-1705 (5/4/2011)
Hi is this what you needed--
Hmm, I don't agree - drew.allen's post describes what is needed IMO.
Im Humm..
What is wrong with the above code i...
May 4, 2011 at 4:36 am
parthi-1705 (5/4/2011)
Hi is this what you needed--
Hmm, I don't agree - drew.allen's post describes what is needed IMO.
May 4, 2011 at 4:20 am
If I read this literally, I come to the conclusion that data has been imported to a table whose name is 'query', which is somewhat confusing, to say the least!
May 4, 2011 at 2:38 am
kaps.manshani (5/3/2011)
But, this information won't help as the job is already running with some proxy account. And this account has the privileges to access the database.
However, I...
May 3, 2011 at 3:52 am
Script Task or Script Component?
Does this validation happen as part of the data flow or before it?
May 3, 2011 at 3:04 am
This is probably a permissions-related issue. I am guessing that when you run it manually, it accesses the db via Windows authentication and your account has the necessary permissions to...
May 3, 2011 at 2:21 am
srikant maurya (5/3/2011)
I have an SSIS package to import the data from SQL SERVER TABLE . Iworking fine for 900 row(it's take less than 1 min) but when i...
May 3, 2011 at 2:12 am
Chrissy321 (5/2/2011)
May 2, 2011 at 1:30 pm
You'll need a hex editor to see the 'invisible' characters.
May 2, 2011 at 12:01 pm
Viewing 15 posts - 11,416 through 11,430 (of 13,859 total)