Re: how to parameterize a dts package?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

The global parameters can be mapped to properties of your connection tasks.
At design time a file must exist in order to save any changes to the
connection task
but as specified the global parameter mapping will take over when it's run.

Bye,
Peter
"Peter Rilling" <peter@xxxxxxxxxxxxxxxxxx> wrote in message
news:e8Cv9tOAGHA.216@xxxxxxxxxxxxxxxxxxxxxxx
> Will this also allow me to change the source location of a text file
> connection? I want to specify the location at runtime but the Sql
> designer requires a file path.
>
> "Darren Green" <darren.green@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:uULPxoOAGHA.2132@xxxxxxxxxxxxxxxxxxxxxxx
>> Peter Rilling wrote:
>>> Hi.
>>>
>>> I am creating a DTS package that has a number of tasks. The primary
>>> purpose of this DTS is to import and process data from local delimited
>>> file.
>>>
>>> I have a data source connection that wraps the source file content and
>>> allows the system to see it as just another database.
>>>
>>> Right now the path to the local files are hardcode. I would like them
>>> to be dynamic. Is there any way to parameterize the DTS so that I can
>>> simply pass information just as file paths into the package.
>>>
>>>
>>
>> Look at using the Dynamic Properties task to read from a location and
>> assign the property. If you need to manipulate the values then use an
>> ActiveX Script Task.
>>
>> Another good way of passing data into a package is to use global
>> variables, which can be set through the /A parameter for DTSRUN.
>>
>> This may be of use-
>>
>> How can I change the filename for a text file connection?
>> (http://www.sqldts.com/default.aspx?200)
>>
>> --
>> Darren
>> http://www.sqldts.com
>> http://www.sqlis.com
>
>


.

Relevant Pages

  • [SLE] Samba Problems
    ... when I try smbclient -L papa I get the message "Connection to papa ... Active Internet connections (servers and established) ...
    (SuSE)
  • RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Vari
    ... The master package template contains two sequence containers. ... I noticed that I had not connected my first sequence container to ... Instead of using an OUTPUT parameter in the sp, set the Execute SQL Task (on ... With stored procedures, the other connection ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Global Variable problem - type mismatch
    ... But the problem is that the package still fails to run. ... of the properties within the DTS and run it from there then it works. ... > reference to the connection I have in my DTS. ...
    (microsoft.public.sqlserver.dts)
  • Re: create dynamic dts package
    ... In my reply I said that all this may not be necessary and you may be able to simply rebuild the Transform data Task in an existing package. ... Dim oConnProperty As OleDBProperty ... ' create package connection information ... Dim oConnection As Connection2 ...
    (microsoft.public.sqlserver.dts)
  • RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Vari
    ... Instead of using an OUTPUT parameter in the sp, set the Execute SQL Task (on ... With stored procedures, the other connection ... listed in the stored procedure, which makes the connection a little more ... I've created a Master Package that will be used as a template for developing ...
    (microsoft.public.sqlserver.dts)