Not that I can think of, though there is more than one way of doing it:

1) In the SQL source.

This is probably where I would do it.

2) In SSIS -...

One way or another, you're going to have to do a replace somewhere, as there is no global option to tell Excel to display blank cells as NULL, to my...

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