Changing DTS Package Properties

#1

Hello there

I've belt DTS package that import data from access file

On the DTS i gave path to the access file.

Is there a way to change the path of the Access connection on the DTS
package befure i execute it?

#2

There most certainly is

How can I change the filename for an Access Connection?
(http://www.sqldts.com/default.aspx?201)

--

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

"Roy Goldhammer" <roygoldh (AT) hotmail (DOT) com> wrote

Quote:

Hello there

I've belt DTS package that import data from access file

On the DTS i gave path to the access file.

Is there a way to change the path of the Access connection on the DTS
package befure i execute it?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Changing DTS Package Properties

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Changing DTS Package Properties - 04-03-2004 , 07:39 AM

Re: Changing DTS Package Properties - 04-04-2004 , 09:59 AM