Thank you, I will give this a go!
-----Original Message-----
From: tweir
[mailto:mssqldba-ezmlmshield-x92054379.[Email address protected]
Sent: 27 May 2005 13:29
To: LazyDBA Discussion
Subject: Re: BCP
You can set up a global variable and, using a dynamic properties task,
change the name of the output file on-the-fly.
Example:
ExecuteSQL step:
Query: select 'ExportFile_' + convert(char(8),getdate(),112) + '.txt'
as ExportFile
Click the Parameters button
Click the Create Global Variables button
Enter "ExportFile" in the Name column
Click OK
Click the Output Parameters tab
Click the Row Value Button
Under the Output Global Variables column, click the word <none>
Select "ExportFile" from the drop down list
Click OK
Click OK again
In your Text File Destination object, click the Properties button and
check the "First row has column names" box
Add a Dynamic Properties Task
Click the Add button
Expand the Connections list, find your text file, double-click the word
DataSource in the list to the right
On the Source drop-down list, select Global Variable
On the Variable drop-down list, select "ExportFile"
Click OK
Expand the OLE DB Properties List, and click the 1st item "Data Source"
Double-click the word "Value" in the table to the right
On the Source drop-down list, select Global Variable
On the Variable drop-down list, select "ExportFile"
Click OK
Add an "On Success" arrow from the dynamic properties task to your
export task.
Run the package and it will create a file named ExportFile_YYYYMMDD.txt
with the column headings.
Trevor
----- Original Message -----
From: Aarons Simon <mssqldba-ezmlmshield-
x67176857.[Email address protected]
Date: Friday, May 27, 2005 8:03 am
Subject: BCP
>
>
> Afternoon All!
>
>
>
> When you bcp something as simple as "select * from MyTable" to a text
> file, can you also export the column headings as well. The aim is to
> export data but the user, who will import to excel during the day at
> some point needs the column headings.
>
>
>
> Before you ask, I would normally run a DTS with excel export but I
> don'tknow how to dynamically change the date of the excel file,
> thus not to
> overwrite...
>
>
>
> Thanks in advance
>
>
>
> Simon
>
>
> -------------------------------------------------------------
> 120 years of the MDU: Still the leading choice
> -------------------------------------------------------------
> MDU Services Limited (MDUSL) is authorised and regulated
> by the Financial Services Authority in respect of insurance
> mediation activities only. MDUSL is an agent for Zurich
> Insurance Company and Converium Insurance (UK) Limited. In
> Ireland, MDUSL is a tied agent of Eagle Star Insurance
> Company (Ireland) Ltd and is regulated by the Irish Financial
> Services Regulatory Authority. MDUSL is an agent for the
> Medical Defence Union (the MDU). The MDU is not an
> insurance company. The benefits of membership of the MDU
> are all discretionary and are subject to the Memorandum and
> Articles of Association.
>
> MDU Services Limited Registered in England 03957086.
> Registered Office: 230 Blackfriars Road London SE1 8PJ
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>
>
> -------------------------------------------------------------------
> --
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
-------------------------------------------------------------
120 years of the MDU: Still the leading choice
-------------------------------------------------------------
MDU Services Limited (MDUSL) is authorised and regulated
by the Financial Services Authority in respect of insurance
mediation activities only. MDUSL is an agent for Zurich
Insurance Company and Converium Insurance (UK) Limited. In
Ireland, MDUSL is a tied agent of Eagle Star Insurance
Company (Ireland) Ltd and is regulated by the Irish Financial
Services Regulatory Authority. MDUSL is an agent for the
Medical Defence Union (the MDU). The MDU is not an
insurance company. The benefits of membership of the MDU
are all discretionary and are subject to the Memorandum and
Articles of Association.
MDU Services Limited Registered in England 03957086.
Registered Office: 230 Blackfriars Road London SE1 8PJ
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
MS Sql Server LazyDBA home page