How to dyamicly change excel connection string

#1

Hi,
I have one problem.

In SQL 2005 I have SSI package to export data to some excel files.
I have for loop container with some job (one of the job is generate file
name for exporting data and put the name into variable).
My question is how I can dynamicly change Excel Connection Manager to point
to excel file with the name from my variable?

Thanks in advance.

Radovan

#2

Use a Property Expression and assign the variable's value to the
ExcelFilePath property of the Excel Connection Manager.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

"Radovan" <radovan (AT) servis24 (DOT) hr> wrote

Quote:

Hi,
I have one problem.

In SQL 2005 I have SSI package to export data to some excel files.
I have for loop container with some job (one of the job is generate file
name for exporting data and put the name into variable).
My question is how I can dynamicly change Excel Connection Manager to point
to excel file with the name from my variable?

Thanks in advance.

Radovan

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

How to dyamicly change excel connection string

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

How to dyamicly change excel connection string - 12-29-2006 , 08:39 AM

Re: How to dyamicly change excel connection string - 12-29-2006 , 08:45 AM