Passing a parameter to DTS Package

#1

Hi,

I am developing a DTS package to import a file from some location.
But every time the location of the file will not be the same so I want
to pass a file name as an input parameter.
How can I do it?

Thanks for any help

Kedar

#2

Hello Kedar,
in DTS: Packace:Properties:Global Variables

HTH
JÃ¶rg

"Kedar" wrote:

Quote:

Hi,

I am developing a DTS package to import a file from some location.
But every time the location of the file will not be the same so I want
to pass a file name as an input parameter.
How can I do it?

Thanks for any help

Kedar

#3

Look at the following white paper. It has several suggestions.
http://msdn.microsoft.com/library/de..._dts_ssabi.asp

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Joerg" <Joerg (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello Kedar,
in DTS: Packace:Properties:Global Variables

HTH
Jörg

"Kedar" wrote:

Hi,

I am developing a DTS package to import a file from some location.
But every time the location of the file will not be the same so I want
to pass a file name as an input parameter.
How can I do it?

Thanks for any help

Kedar

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

Passing a parameter to DTS Package

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Passing a parameter to DTS Package - 07-15-2004 , 06:06 AM

RE: Passing a parameter to DTS Package - 07-15-2004 , 07:05 AM

Re: Passing a parameter to DTS Package - 07-16-2004 , 01:06 AM