Refreshing a CSV file using DTS

I have a DTS job that populates a CSV file on a regular basis.
It appears that by default, each time the job runs the contents of the file
are overwritten with the new data from SQL Server.
Can anyone that confirm that this is the case?
And is it possible to have DTS append to rather than overwrite the contents
of the file?
That's correct...the default is to overwrite.
The append option isn't supported with the text file
provider. The workaround is generally to generate a second
file and then use FileSystemObject to create a single file
or a dos copy command to combine the two file into a third
file.
-Sue
On Thu, 24 Feb 2005 07:22:52 -0800, "Dave" <dave@.nospam.ru>
wrote:

>I have a DTS job that populates a CSV file on a regular basis.
>It appears that by default, each time the job runs the contents of the file
>are overwritten with the new data from SQL Server.
>Can anyone that confirm that this is the case?
>And is it possible to have DTS append to rather than overwrite the contents
>of the file?
>
sql

Refreshing a CSV file using DTS

I have a DTS job that populates a CSV file on a regular basis.
It appears that by default, each time the job runs the contents of the file
are overwritten with the new data from SQL Server.
Can anyone that confirm that this is the case?
And is it possible to have DTS append to rather than overwrite the contents
of the file?That's correct...the default is to overwrite.
The append option isn't supported with the text file
provider. The workaround is generally to generate a second
file and then use FileSystemObject to create a single file
or a dos copy command to combine the two file into a third
file.
-Sue
On Thu, 24 Feb 2005 07:22:52 -0800, "Dave" <dave@.nospam.ru>
wrote:

>I have a DTS job that populates a CSV file on a regular basis.
>It appears that by default, each time the job runs the contents of the file
>are overwritten with the new data from SQL Server.
>Can anyone that confirm that this is the case?
>And is it possible to have DTS append to rather than overwrite the contents
>of the file?
>

Refreshing a CSV file using DTS

I have a DTS job that populates a CSV file on a regular basis.
It appears that by default, each time the job runs the contents of the file
are overwritten with the new data from SQL Server.
Can anyone that confirm that this is the case?
And is it possible to have DTS append to rather than overwrite the contents
of the file?That's correct...the default is to overwrite.
The append option isn't supported with the text file
provider. The workaround is generally to generate a second
file and then use FileSystemObject to create a single file
or a dos copy command to combine the two file into a third
file.
-Sue
On Thu, 24 Feb 2005 07:22:52 -0800, "Dave" <dave@.nospam.ru>
wrote:
>I have a DTS job that populates a CSV file on a regular basis.
>It appears that by default, each time the job runs the contents of the file
>are overwritten with the new data from SQL Server.
>Can anyone that confirm that this is the case?
>And is it possible to have DTS append to rather than overwrite the contents
>of the file?
>

Referencing/setting properties of an object

Is there any way to set the properties of one object depending on the
contents of a textbox or other object in a report? I'm trying to hide a
table column when the report is rendered if the footer value is zero.
Thanks in advance!You can use an expression on the visibility hidden properties of the header,
details & footer cell of the column you want to hide.
=IIF(ReportItems!colfooter1.Value is nothing,True,False)
where colfooter1 contains the value you are checking for zero.
hope that helps
Mark
"Boilin'Oil" wrote:
> Is there any way to set the properties of one object depending on the
> contents of a textbox or other object in a report? I'm trying to hide a
> table column when the report is rendered if the footer value is zero.
> Thanks in advance!

Referencing a Control's Value Property

I'm trying to reference a image control value property. I want to show
the contents of the value property in a textbox control. I thought I
saw this before but cannot seem to find it again.
For example, I have an image control called image1. Which has a value
of: C:\images\xxxx.jpg
In a textbox I want to show "C:\images\xxxx.jpg"
I'm trying something like: textbox.value=image1.value
So when I preview the report I get an image, and a textbox that shows
the value used for the text box.
Any ideas?
Thanks,
rwiethornCurrently, the only Value property exposed to expressions is Textbox.Value
(in fact, the only report items visible to expressions at all are
textboxes).
But... You could achieve the desired result by making the value of the image
control an expression that refers to the contents of the textbox:
=ReportItems!Textbox1.Value
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"rwiethorn" <rwiethorn2002@.yahoo.com> wrote in message
news:553a0349.0408230522.2226ad4d@.posting.google.com...
> I'm trying to reference a image control value property. I want to show
> the contents of the value property in a textbox control. I thought I
> saw this before but cannot seem to find it again.
> For example, I have an image control called image1. Which has a value
> of: C:\images\xxxx.jpg
> In a textbox I want to show "C:\images\xxxx.jpg"
> I'm trying something like: textbox.value=image1.value
> So when I preview the report I get an image, and a textbox that shows
> the value used for the text box.
> Any ideas?
> Thanks,
> rwiethorn

Reducing Disk I/O in SQL Server configuration

Hi All,
We have a SQL server database in which the contents are updated for
every few seconds(it can be as low as 4 sec). Therefore the tablesize
will keep growing continuously. There is a problem in the table design
itself. It has been designed without any primary key. I know this will
make the insertion slower. If we rectify this, what else should we do
in the SQL Server side to reduce the Disk I/O access for the database.
The harddisk LED keeps flashing continuosly.
Thanks
Hi
Does the table have any indexes?
<vanisathish@.gmail.com> wrote in message
news:1123756244.000317.291730@.z14g2000cwz.googlegr oups.com...
> Hi All,
> We have a SQL server database in which the contents are updated for
> every few seconds(it can be as low as 4 sec). Therefore the tablesize
> will keep growing continuously. There is a problem in the table design
> itself. It has been designed without any primary key. I know this will
> make the insertion slower. If we rectify this, what else should we do
> in the SQL Server side to reduce the Disk I/O access for the database.
> The harddisk LED keeps flashing continuosly.
> Thanks
>

Reducing Disk I/O in SQL Server configuration

Hi All,
We have a SQL server database in which the contents are updated for
every few seconds(it can be as low as 4 sec). Therefore the tablesize
will keep growing continuously. There is a problem in the table design
itself. It has been designed without any primary key. I know this will
make the insertion slower. If we rectify this, what else should we do
in the SQL Server side to reduce the Disk I/O access for the database.
The harddisk LED keeps flashing continuosly.
ThanksHi
Does the table have any indexes?
<vanisathish@.gmail.com> wrote in message
news:1123756244.000317.291730@.z14g2000cwz.googlegroups.com...
> Hi All,
> We have a SQL server database in which the contents are updated for
> every few seconds(it can be as low as 4 sec). Therefore the tablesize
> will keep growing continuously. There is a problem in the table design
> itself. It has been designed without any primary key. I know this will
> make the insertion slower. If we rectify this, what else should we do
> in the SQL Server side to reduce the Disk I/O access for the database.
> The harddisk LED keeps flashing continuosly.
> Thanks
>

Reducing Disk I/O in SQL Server configuration

Hi All,
We have a SQL server database in which the contents are updated for
every few seconds(it can be as low as 4 sec). Therefore the tablesize
will keep growing continuously. There is a problem in the table design
itself. It has been designed without any primary key. I know this will
make the insertion slower. If we rectify this, what else should we do
in the SQL Server side to reduce the Disk I/O access for the database.
The harddisk LED keeps flashing continuosly.
ThanksHi
Does the table have any indexes?
<vanisathish@.gmail.com> wrote in message
news:1123756244.000317.291730@.z14g2000cwz.googlegroups.com...
> Hi All,
> We have a SQL server database in which the contents are updated for
> every few seconds(it can be as low as 4 sec). Therefore the tablesize
> will keep growing continuously. There is a problem in the table design
> itself. It has been designed without any primary key. I know this will
> make the insertion slower. If we rectify this, what else should we do
> in the SQL Server side to reduce the Disk I/O access for the database.
> The harddisk LED keeps flashing continuosly.
> Thanks
>