Viewing 15 posts - 4,336 through 4,350 (of 9,712 total)
I would like to be able to use Powershell from within SSIS to do things like file management (without having to have xp_cmdshell enabled). The sort of things that the...
June 7, 2012 at 6:37 am
So, the house next door went up for short sale. I've seen this house at its worst (when it needed a serious overhaul) and it's looking pretty good right now....
June 6, 2012 at 4:55 am
GilaMonster (6/6/2012)
Revenant (6/5/2012)
June 6, 2012 at 4:53 am
Please start a new thread, Suresh. It's considered impolite to hijack a thread with questions that have little to do with the original subject. Especially older threads like this one.
June 5, 2012 at 5:32 am
Gianluca Sartori (6/4/2012)
mtillman-921105 (6/1/2012)
So I suppose a lot of people rent in Europe?
70% of Italians own the house they live in.
Well, sort of.
Who owns the house while you're paying the...
June 4, 2012 at 9:01 am
My data source is a stored procedure which does a SELECT at the end, then sends records in two different directions. One to the file and one to a staging...
June 4, 2012 at 7:49 am
SKYBVI (6/4/2012)
If you memorise answers, you will be lost as soon as the interviewer digs into details. If you've played around and have practical experience you won't be.
Thats true I...
June 4, 2012 at 5:29 am
SKYBVI (6/4/2012)
1) Why clustered index are only 1 and non clustered indexes are many?
Also, if for a table we...
June 4, 2012 at 4:32 am
jcrawf02 (6/1/2012)
Koen Verbeeck (6/1/2012)
SSIS is a littly crybaby when it comes to changing metadata.Ha! So true...
I hate the XML Source. Any changes to the XSD file, and you have...
June 1, 2012 at 6:27 am
My recommendation. Make sure your SQL schema (as Koen said) is the same in the development environment. Get local copies of all dbs for development. Do some unit testing to...
June 1, 2012 at 5:51 am
Happy release day to meeeeeeee.
Legend of the Beemen & the June issue of Penumbra eMag (of which I was guest editor-in-chief) are now available for purchase: http://www.musapublishing.com/%5B/url%5D
Buy it... Buy it......
June 1, 2012 at 5:10 am
Koen Verbeeck (6/1/2012)
Cath Trimble (6/1/2012)
By the way, the houses near the tech center sure are expensive - about $250,000 and up I think?
Wow, that's cheap by UK standards....
June 1, 2012 at 5:06 am
Is SSIS integrated with Powershell?
May 31, 2012 at 12:06 pm
DOH!
Nevermind. I found the issue. I got my subtraction in the end length wrong.
Code is now:
(DT_STR,10,1252)SUBSTRING(AllOtherData,382,FINDSTRING(AllOtherData,"~",3) - 382)
May 31, 2012 at 11:18 am
There is no guarantee this would be faster, but try a WHILE loop (using your records as a decrementing counter) and see if that has any better performance than a...
May 31, 2012 at 8:04 am
Viewing 15 posts - 4,336 through 4,350 (of 9,712 total)