March 12, 2008 at 6:35 am
Firstly, does anyone know of any good SSIS books that go in depth on the different data flow tasks?
I'm not talking the 1 page "brief" descriptions that are in books like "Hands-On Microsoft SQL Server 2005 Integration Services". I'm talking advanced stuff. Like what situations to use these different tasks in and how you can actually program them.
Secondly, what source can I use to read a RecordSet Destination? Or can I use a source object to read an RS Destination? Are these only readable by script tasks?
What I want to do is take my data from the different original sources, do some scrubbing, then either pop it into a Temp Table or an RS Destination, do some T-SQL on it, then pull it back out again. But I can't figure out how to use an OLE DB Command after other tasks (like Merge or Derived Columns) and I can't figure out how to read from an RS Destination.
Thoughts? Thanks in advance!
March 12, 2008 at 6:48 am
Not sure this is exactly what you are looking for but it has helped me and my co-worker with developing SSIS packages: Professional SQL Server Integratin Services 2005 (I think, the book is in my car and not handy) by WROX. I keep this book with me when I am working on SSIS packages, which is why it's in the car so I can have it at work also. (You should see the portable library I have in the trunk of my car!)
😎
March 12, 2008 at 6:52 am
Hmm. I work with one of the authors of that book. I wonder if he has his copy in the office.
Thanks, Lynn. I'll check into that.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply