Viewing 15 posts - 8,701 through 8,715 (of 9,715 total)
gpriester (8/27/2008)
declare @int_num int
select @int_num...
August 27, 2008 at 10:29 am
Jack,
RE: The Age subtraction. Yeah, I did subtract it at home, it's just that fumble fingers didn't type it correctly in her post. @=)
ISDATE()! DOH! I knew...
August 27, 2008 at 10:20 am
The only way I could see doing it is through iteration. Ie, the dreaded cursor or a While Loop.
I've never seen anyone assign values to multiple variables in one statement,...
August 27, 2008 at 8:58 am
I think I just found an odd workaround to this problem.
When I edit the FF connection, it says there are no columns defined. If I go into a copy of...
August 27, 2008 at 4:56 am
If you're trying to avoid using the OLE DB Command in the Data Flow (which I recommend because it's RBAR), then you might try using a Derived Column transformation after...
August 27, 2008 at 3:57 am
Frank raises several good points, especially about what a resource hog SSIS can be if it's on the same server as a DW or heavily used OLTP DB. Everything should...
August 26, 2008 at 11:20 am
riga1966 (8/26/2008)
You wrote:
On the other hand, there are other situations where you can't do what you need by using an Execute SQL Task. I always look at both situations first...
August 26, 2008 at 9:16 am
No flames here. @=)
I don't know how it works in 2008, but I have done tests in 2005 where an Execute SQL task has proved 5 times faster than doing...
August 26, 2008 at 8:41 am
Michael,
I understand that perfectly. But I don't know DTS very well, so trying to figure out what the package was actually doing was driving me batty.
I just discovered my REAL...
August 26, 2008 at 7:47 am
This sounds like a database design issue, not an SSIS issue. If I'm wrong, please post more details, like the design of your tables & flat files and the...
August 26, 2008 at 5:28 am
The OLE DB Command in Data Flow works on a Row By Row basis. RBAR at its finest. @=)
If you have something huge to update, you're better off trying to...
August 26, 2008 at 5:18 am
I don't know about the second one, but I think you need to write some SQL code to "ping" the server or do a simple select statement on a small...
August 26, 2008 at 5:16 am
I understand your boss's problem and here's the simple solution to maintain performance and to make him happy.
Take all the code in those Execute SQL Tasks and make them stored...
August 26, 2008 at 5:14 am
Great. Yet another thing to delay the conversion of our "end of lease" box. Boss is going to love this one.
I voted on the issue and commented. I guess I'd...
August 26, 2008 at 4:44 am
I've looked around and can't seem to find anything about creating the variables at run time. I'm sorry. The closest I can come is Dynamic SQL which you could stick...
August 25, 2008 at 12:57 pm
Viewing 15 posts - 8,701 through 8,715 (of 9,715 total)