Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 4 of 4
Search took 0.01 seconds.
Search: Posts Made By: lavisualstudio
Forum: BOOK: Professional Microsoft SQL Server 2008 Integration Services ISBN: 978-0-470-24795-2 August 4th, 2010, 11:21 PM
Replies: 0
Views: 1,309
Posted By lavisualstudio
SMO Table Name and Update

I'm trying to perform and update to a variable in a For Each Loop for SMO table objects.
My syntax is failing:

Dts.Variables("varSelect").Value = "Select * from " +...
Forum: BOOK: Professional Microsoft SQL Server 2008 Integration Services ISBN: 978-0-470-24795-2 August 4th, 2010, 10:19 PM
Replies: 0
Views: 1,317
Posted By lavisualstudio
Extract Query from OLEDB Datasource

I'd like to extract the full query from an OLEDB Datasource.
Does anyone have an example of how this is done?
THank you
Forum: BOOK: Professional Microsoft SQL Server 2008 Integration Services ISBN: 978-0-470-24795-2 March 13th, 2010, 09:55 PM
Replies: 0
Views: 2,831
Posted By lavisualstudio
Export Column Header to Text File in SSIS

It doesn't appear that Column Headers can be exported to a text file.
Does anyone have a workaround for this ?
Thanks
Forum: BOOK: Professional Microsoft SQL Server 2008 Integration Services ISBN: 978-0-470-24795-2 March 13th, 2010, 06:18 PM
Replies: 1
Views: 1,374
Posted By lavisualstudio
Send Mail for Each Record in a Select Statement

In Chapter 13 of Microsoft SQL Server 2008 Integration Services, it explains how to send start, end times of a package, etc.

We would like to modify this very simple example in Chapter 13 to...
Showing results 1 to 4 of 4

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.