Dynamic Output File Naming

#1

I've just started using SQL Server 2005 Integration Services and
I've come up against a situation where I need to name output files
dynamically (i.e. based on a timestmap). Looking through this
newsgroup and other resources it looks like my only option is to use a
Script Task (ActiveX looks the easiest) to rename the file after it has
been created with a generic file name.
I was wondering if there was a different approach that would allow
me to pass in a variable to the file connection manager that would
allow me to assign the file name dynamically at run-time.

Thanks
Bill

#2

Hello Bill,

Sure there is and the solution is called Property Expressions

This article will help

http://wiki.sqlis.com/default.aspx/S...cLocation.html

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

I've just started using SQL Server 2005 Integration Services and
I've come up against a situation where I need to name output files
dynamically (i.e. based on a timestmap). Looking through this
newsgroup and other resources it looks like my only option is to use a
Script Task (ActiveX looks the easiest) to rename the file after it
has
been created with a generic file name.
I was wondering if there was a different approach that would allow
me to pass in a variable to the file connection manager that would
allow me to assign the file name dynamically at run-time.

Thanks
Bill

#3

Allan,
Thanks the link that made it pretty clear what I needed to do.

Bill LaMorre

Allan Mitchell wrote:

Quote:

Hello Bill,

Sure there is and the solution is called Property Expressions

This article will help

http://wiki.sqlis.com/default.aspx/S...cLocation.html

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

I've just started using SQL Server 2005 Integration Services and
I've come up against a situation where I need to name output files
dynamically (i.e. based on a timestmap). Looking through this
newsgroup and other resources it looks like my only option is to use a
Script Task (ActiveX looks the easiest) to rename the file after it
has
been created with a generic file name.
I was wondering if there was a different approach that would allow
me to pass in a variable to the file connection manager that would
allow me to assign the file name dynamically at run-time.

Thanks
Bill

#4

Allan,
Thanks, that link that made it pretty clear what I needed to do.

Bill LaMorre

Allan Mitchell wrote:

Quote:

Hello Bill,

Sure there is and the solution is called Property Expressions

This article will help

http://wiki.sqlis.com/default.aspx/S...cLocation.html

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

I've just started using SQL Server 2005 Integration Services and
I've come up against a situation where I need to name output files
dynamically (i.e. based on a timestmap). Looking through this
newsgroup and other resources it looks like my only option is to use a
Script Task (ActiveX looks the easiest) to rename the file after it
has
been created with a generic file name.
I was wondering if there was a different approach that would allow
me to pass in a variable to the file connection manager that would
allow me to assign the file name dynamically at run-time.

Thanks
Bill

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

Dynamic Output File Naming

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

Dynamic Output File Naming - 03-10-2006 , 03:02 PM

Re: Dynamic Output File Naming - 03-11-2006 , 03:16 AM

Re: Dynamic Output File Naming - 03-13-2006 , 11:12 AM

Re: Dynamic Output File Naming - 03-13-2006 , 11:13 AM