Re: How do I dynamically change output text file properties?
- From: JXStern <JXSternChangeX2R@xxxxxxx>
- Date: Wed, 21 Feb 2007 08:41:06 -0800
On Tue, 20 Feb 2007 17:03:58 -0600, "LarryKruse"
<hfdsweblizard@xxxxxxxxxxx> wrote:
I have a series of 30 stored procedures which extract data from a SQL Server
warehouse.
The procedures extract the data and I can individually create a DTS package
which writes the result set to a .csv text file. (These files will be
imported into a 3rd party package.)
What I'm trying to do is to come up with a way that I can dynamically change
the text file name dynamically as I loop through a list of the 30 stored
procedures.
I can find lots of DTS sample code showing how to manipulate the properties
of a destination source when that source is a SQL Server table, but nothing
that shows how to access even the filename of the Destination Text file
properties.
Has anyone done this?
Sure.
You can use a dynamic properties task to browse a text file
destination, then use the task or code to set the properties.
J.
.
- References:
- How do I dynamically change output text file properties?
- From: LarryKruse
- How do I dynamically change output text file properties?
- Prev by Date: Re: Renaming db for all connections (Russel Loski)
- Next by Date: SQL 2000, DTS - using parameter with many values
- Previous by thread: How do I dynamically change output text file properties?
- Next by thread: generic FTP job .. ssis ftp task passed parameters??
- Index(es):
Relevant Pages
|
