Viewing 15 posts - 11,431 through 11,445 (of 13,876 total)
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 -...
May 10, 2011 at 4:22 am
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...
May 10, 2011 at 2:11 am
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
Viewing 15 posts - 11,431 through 11,445 (of 13,876 total)