Hi all
I have a package reading data from an ini file in the first step.
I need to move the package on production server (on e:, i developed on my PC
in c , but I haven't found any way to change the path of the ini file

Exporting in BAS, it seems not bo be a properyt of dynamictransformation
task, but related to every item of it

So i use an INI file to change path for data files to be imported, but what
for changing INI path?

Hello, Roberto!

I would have a "Common" path for the INI file and always place it in the
same place every time.

How to add a Dynamic Properties task to a package and manipulate it using
VB.
http://www.sqldts.com/default.aspx?6,102,252,0,1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: Exporting in BAS, it seems not bo be a properyt of dynamictransformation
: task, but related to every item of it

--- Microsoft Outlook Express 6.00.2800.1158

hi, allan
Unfortunately the production server has data on e: (c: is operating system,
d: is reserved), i can't change it :-(
I discovered this in last days, i built package completely in c: (e: is
CDrom)
ok, i can change e: to z: , i can share a dir as e: , and probably it works,
but how can adapt my package? only manually?
and if they decide to move everithing on a (new) f: drive? change manually
again?


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello, Roberto!

Another solution is

Have a Controller database on a Controller Server.

Create an alias using Client Network Utility to it using a friendly name i.e
MyController

You can then reference this server in your dynamic properties task by using
a query against it.

On each server that you deploy this package to you create an alias with the
same name. This will then enable the package to read from the DB table.
The DB could be hosted on any server this way.



--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
: news:us87pyGRDHA.2036 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
??>> Hello, Roberto!
??>>
??>> I would have a "Common" path for the INI file and always place it in
the
??>> same place every time.
??>>
??>> How to add a Dynamic Properties task to a package and manipulate it
using
??>> VB.
??>> http://www.sqldts.com/default.aspx?6,102,252,0,1
??>>
??>> --
??>>
??>> Allan Mitchell (Microsoft SQL Server MVP)
??>> MCSE,MCDBA
??>> www.SQLDTS.com
??>> I support PASS - the definitive, global community
??>> for SQL Server professionals - http://www.sqlpass.org
??>>
??>> : Exporting in BAS, it seems not bo be a properyt of
dynamictransformation
??>> : task, but related to every item of it
??>>
--- Microsoft Outlook Express 6.00.2800.1158