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 🙂

Grrr, pipped at the post by Lowell 🙂

The system is defaulting to integer arithmetic.

Try dividing by 1024.0 to force real precision.

kaps.manshani (5/5/2011)

---

Uripedes Pants (5/4/2011)

---

if it's in vb6.... do you own the code? If so, you could put some logging into it to tell you which pieces run OK. ...

SKYBVI (5/4/2011)

---

Why...

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

parthi-1705 (5/4/2011)

---

Im Humm..

What is wrong with the above code i...

Hmm, I don't agree - drew.allen's post describes what is needed IMO.

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!

kaps.manshani (5/3/2011)

---

Thanks for the reply.

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

Script Task or Script Component?

Does this validation happen as part of the data flow or before it?

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

srikant maurya (5/3/2011)

---

Hi All,

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

Chrissy321 (5/2/2011)

---

Thank you both. This has been educational and I have been able to unequivocally demonstrate to my very expensive and supposedly enterprise-level vendor that their product is just not...

You'll need a hex editor to see the 'invisible' characters.