How can get the global variable value as a MsAccess Filename.

#1

hi,
I have a DTS, which will run from DTSRun utility.
And I am converting msaccess database to SQL database.
Now i want to Get the msaccess file dynamically from
user.
I am getting this by global variable name as conString.

now How can i put this as a MSaccess Data Source
filename in MSaccess Connection?

Please help me..

Thanks in Advance.

with regards,
Prakash.

#2

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

-Sue

On Sun, 5 Oct 2003 23:41:13 -0700, "Prakash"
<dharmaprakash (AT) prudencetech (DOT) com> wrote:

Quote:

hi,
I have a DTS, which will run from DTSRun utility.
And I am converting msaccess database to SQL database.
Now i want to Get the msaccess file dynamically from
user.
I am getting this by global variable name as conString.

now How can i put this as a MSaccess Data Source
filename in MSaccess Connection?

Please help me..

Thanks in Advance.

with regards,
Prakash.

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

How can get the global variable value as a MsAccess Filename.

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

How can get the global variable value as a MsAccess Filename. - 10-06-2003 , 01:41 AM

Re: How can get the global variable value as a MsAccess Filename. - 10-06-2003 , 07:44 AM