Viewing 15 posts - 8,701 through 8,715 (of 9,720 total)
Yeah. I know, Carl. But when I said it was easy, I meant that it's hard to make the result of a Year function unconvertible to a datetime. I knew...
August 28, 2008 at 4:21 am
The speed of SSIS is supposed to be much better in SQL 2008. Apparently MS learned from the 2005 implementation and have added some "umph" to the engine. @=)
August 28, 2008 at 4:09 am
Small example.
In your dataflow, you have the following:
OLE DB Source1 -> Stage_DDA_Rev_Adj
OLE DB Source2 -> CIS_ACCount
--NOTE: Both sources have to be sorted. Advanced Editor, go to last tab, click on...
August 27, 2008 at 12:44 pm
Oh, believe me. I know that pain. I have approximately 150 nested formulas I had to redo from an excel workbook report so I could automate the report.
Nested upon nested...
August 27, 2008 at 10:55 am
Actually, looking back at your example, I'm not even seeing the reason you need to use variables at all. Why not just do your Select statements without them?
Going with...
August 27, 2008 at 10:34 am
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
Viewing 15 posts - 8,701 through 8,715 (of 9,720 total)