Viewing 15 posts - 10,741 through 10,755 (of 13,879 total)
Yes, using dataflow tasks.
Sounds like you might have some reading up to do!
May 7, 2012 at 11:29 am
haichells (5/7/2012)
May 7, 2012 at 4:35 am
A simple SSIS package would do this easily, if that is an option.
May 7, 2012 at 3:54 am
haichells (5/6/2012)
Thanks. But this will not help 🙁 Output should be automatically pushed into CSV and not a manual process.
This requirement sounds flaky to me.
You want an automatic process, and...
May 7, 2012 at 3:38 am
You should try posting this in the DTS forum.
This one is for SSIS.
May 4, 2012 at 4:43 am
If you lookup the function, you'll find that 1/true and 0/false are the only two results it provides per check. You tested the value and found it to be false...
May 1, 2012 at 3:56 pm
kevin.mitchell (5/1/2012)
I trying to carry out some basic file manipualtion within a Script Task.
I have 2 existing files Header.Txt and Footer.txt and I would like to append them to a...
May 1, 2012 at 8:48 am
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is any reference material where...
May 1, 2012 at 7:03 am
You can deduct whatever you want from whatever you like.
This could come in very useful. I'd like to deduct all the French people from the city I live in.
:w00t:...
May 1, 2012 at 6:18 am
justmohit (5/1/2012)
Add this line in Where clauser1.isdirectory!=1
Bye!
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
As the IsSubdirectory column is a Bit column,...
May 1, 2012 at 6:17 am
tt-615680 (5/1/2012)
Would anyone be able to let me know how to resolve the following error message please?
Msg 911, Level 16, State 1, Line 1
Database 'databasename' does not exist....
May 1, 2012 at 6:11 am
Add
WHERE IsDirectory <> Cast(1 as bit)
to the end of your query.
May 1, 2012 at 5:45 am
his has also happened because i could not memorises everyone names and switching back and forth just to check names is not easy.
Actually, it should be very easy. Just have...
May 1, 2012 at 3:24 am
A Rampaging Deduper - who said IT can't be exciting?
April 30, 2012 at 9:17 am
Here is a sample: I guessed what Tara-1044200 was attempting to do.
Indeed & a fair guess. But her post immediately after your suggestion seemed to indicate that things were still...
April 29, 2012 at 12:05 pm
Viewing 15 posts - 10,741 through 10,755 (of 13,879 total)