Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS 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
 
Old June 9th, 2004, 10:55 AM
w3s w3s is offline
Registered User
 
Join Date: Jun 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Creating a Header Row


I am unable to create a header row in the presource step of a multiphase data pump from a SQLServer to a destination text file.

Using the DTS Designer, one the transformations tab, I selected the first field of the destination, I selected presource if the "phases filter" drop down box, and created a new activeX "transformation".

In the activeX script I set the destination column to the text string I wanted to use for my transformation.

When I execute the data pump the text file does not have the header row. And if I test the activeX script (from the little script builder window) the presource step completes successfully, the view results doesn't show and data in the column.

Has anyone ever successfully used the presource step to create a header row in his or her export file?

Thanks,
Wes





Similar Threads
Thread Thread Starter Forum Replies Last Post
Scrollbar in row of Datagrid Except Header Row Theone84 ASP.NET 2.0 Professional 0 August 11th, 2008 12:10 AM
Datagrid fix Header row PramodPatil ADO.NET 3 October 27th, 2007 12:39 AM
Row Header For Cross Tab Report In Crystal Reports padma_eedara ASP.NET 1.0 and 1.1 Basics 1 October 18th, 2006 04:35 AM
How to freeze the header row shankhan Classic ASP Databases 1 April 23rd, 2005 02:18 PM
datagrid header row to appear in vertical fashion justshahid General .NET 1 February 7th, 2005 03:25 PM





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