Viewing 15 posts - 7,681 through 7,695 (of 11,678 total)
L' Eomot Inversé (3/9/2012)
..., but it would be much better if people would behave decently so that we didn't need such a law.
I pay here 21% taxes on CDs. I...
March 9, 2012 at 5:46 am
You can try to store all the records in a recordset destination.
This stores the data into a variable of type object.
In a script task, you can use this variable to...
March 9, 2012 at 4:54 am
Sure.
Log into the SSIS server, export the package to the filesystem (right click on the package), create a new solution in BIDS and add the package.
March 9, 2012 at 4:53 am
I haven't tried it before, but with the /L switch you can associate a logging provider and with the /Rep switch you can set the logging level. It's worth a...
March 9, 2012 at 2:55 am
How deep do you want the course to go?
There are some video's in the SQL Server Developer's Training Kit.
Online course, but not on-demand:
http://pragmaticworks.com/Services/training/Course/Power-Pivot-for-Techies.aspx
March 9, 2012 at 2:48 am
The real answer is: the proc cannot be created because of the flagrant syntax violation.
March 9, 2012 at 12:40 am
LutzM (3/8/2012)
Koen Verbeeck (3/8/2012)
7000 and 4000 are 😛Divisible by 2, 5, 10, 100 and 1000 (and a lot more!)
You might have a different point of view then:
8000 is a round...
March 9, 2012 at 12:30 am
Can't you put the row delimiter to just LF and filter out possible CR's in a derived column?
March 8, 2012 at 11:59 pm
Jeff Moden (3/8/2012)
Ever considered using T-SQL BULK INSERT with a format file?
Stop pulling people away from SSIS dammit 🙂
With SSIS you can do your lookups, event handling and logging all...
March 8, 2012 at 11:57 pm
BSavoie (3/8/2012)
March 8, 2012 at 11:56 pm
7000 and 4000 are 😛
Divisible by 2, 5, 10, 100 and 1000 (and a lot more!)
March 8, 2012 at 3:06 pm
And with this post I neatly arrive at 7000 points! :w00t::w00t::w00t::hehe::hehe::hehe:
(and like Sheldon in the Big Bang Theory, I like nice round even numbers. 7000 points total, 4000 for the...
March 8, 2012 at 2:13 pm
See the first two links in my signature? Read them and then post back. It will allow us to help you a whole lot better.
Right now it's too much guessing...
March 8, 2012 at 2:12 pm
herladygeekedness (3/8/2012)
March 8, 2012 at 2:10 pm
The question is a bit vague, so the only thing I can add is that you will also need a GROUP BY clause to make your query work.
March 8, 2012 at 2:05 pm
Viewing 15 posts - 7,681 through 7,695 (of 11,678 total)