Viewing 15 posts - 1 through 15 (of 25 total)
I know this may be considered as blasphemy and I can barely believe I am suggesting this on here, but you could use a lightweight ORM like Dapper for CRUD...
June 27, 2017 at 6:24 am
This is a good article for how to use a compenent that is very badly documented in Books Online and everywhere else. I used the Script Component transformation to "condense"...
April 23, 2009 at 9:29 am
You are exactly right - i want to compare a field in the current row to a calculated value from the previous row.
I had actually tried something similar in a...
February 27, 2009 at 7:54 am
I've actually found my problem and it wasn't the instr function at all. That worked fine.
It was a second condition in the IIF statement that was comparing an integer to...
February 17, 2009 at 4:54 am
Actually it is #Error i am getting not a blank.
I'm thinking i may need to do some data type conversion in the expression.
February 17, 2009 at 3:49 am
I'm struggling with the same issue. You mention you have a solution and a blog? Any chance of letting me know where I can see this info?
Thanks in advance,
Matt
November 5, 2008 at 5:32 am
Thanks for the links. It's always useful to build up examples and best practices. I have actually merged using the first technique - pre sorting as the data is taken...
September 15, 2008 at 7:15 pm
day,
i'm trying to do an update after doing a merge join. Surely the method you have described updates one row at a time? I've got millions of rows so this...
September 15, 2008 at 5:48 am
SSIS and utilising how to load and export dynamically isn't the most intuitive tool. I would suggest the two things you should start looking into are using variables (in the...
September 14, 2008 at 5:44 pm
Thanks for all comments. I know what you mean about it not being a reference - it isn't. But then again i've been using SSIS for a while and know...
September 5, 2008 at 4:11 am
Just to let people know I have bought the Expert SQL Server 2005 Integration Services from Wrox. The review on Amazon for Professional SQL Server 2005 Integration Services didn't seem...
September 4, 2008 at 6:51 am
Has no one bought a specialist book on SSIS? I find it hard to believe. Help is needed urgently.
September 3, 2008 at 4:49 am
To be totally honest i'm not thinking of packing in the certification just because i won't use it on a day to day basis, but it will be harder than...
November 7, 2007 at 8:46 am
I am a developer so from a point of view of how the servers are set up i haven't really been factoring it into my consideration. Apart from the fact...
November 7, 2007 at 3:12 am
Viewing 15 posts - 1 through 15 (of 25 total)