Hi.

I am having problems using the Send Email Task in DTS Designer.

I have created a CSV file and am attaching this to the email.
Everything is cool until I receive the email. The email has the
attachment, yet the name of the attachment is the full path!! i.e
CTempMyFile.csv (This should be MyFile.csv).

Any help appreciated.

Cheers,

Luke.

Are you dynamically assigning the value or are you doing it through
Designer?
7 or 2000?
Service Pack level?


--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Luke" <luke.gofford (AT) ihsti (DOT) com> wrote

I'm dynamically assigning the value, but I did use a static value before
and it behaved the same.

I'm using SQL 7.

As for the service pack level...I'm not sure?

Cheers,

Luke.

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

do SELECT @@version in QA on the server in question



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Luke Gofford" <luke.gofford (AT) ihsti (DOT) com> wrote