> cannot reach the site, any idea why ?
>
> "Allan Mitchell" wrote:
>
>> Hello Daniel,
>>
>> DTExec is the new way to execute packages from the cmdline in 2005
>>
>> You can build the string you need if you do
>>
>> Start | Run | DTSRunUI
>>
>> The tab you are looking for is "Set Values"
>>
>> A Dsicussion in BOL is here
>>
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlcmpt9/html/89edab2d-fb38-4e8
>> 6-a61e-38621a214154.htm
>>
>> It has the exact thing you are trying to do.
>>
>> Remember though that SSIS is not licenced the same as DTS.
>>
>> --
>>
>> Allan Mitchell
>> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
>> |
>> http://www.konesans.com
>>> hi, in sql2000 I used "dtsrun" to run a DTS package from a stored
>>> procedure and used the /A parameter for passing user variables. How
>>> can i use the "SSIS" to build into the SQL2005 server a new package
>>> and run it from a stored procedure while passing user variables.
>>> thanks.
>>>

> hello Allan,
>
> i run the package with dtexec but i got this error :
>
> [ActiveX Script Task] Error: Retrieving the file name for a component
> failed with error code 0x01AA3424.
>
> the script include only this line ( for testing purpose )
>
> MsgBox(Dts.Variables("myvariable").Value)
>
> "Allan Mitchell" wrote:
>
>> Hello Daniel,
>>
>> DTExec is the new way to execute packages from the cmdline in 2005
>>
>> You can build the string you need if you do
>>
>> Start | Run | DTSRunUI
>>
>> The tab you are looking for is "Set Values"
>>
>> A Dsicussion in BOL is here
>>
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlcmpt9/html/89edab2d-fb38-4e8
>> 6-a61e-38621a214154.htm
>>
>> It has the exact thing you are trying to do.
>>
>> Remember though that SSIS is not licenced the same as DTS.
>>
>> --
>>
>> Allan Mitchell
>> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
>> |
>> http://www.konesans.com
>>> hi, in sql2000 I used "dtsrun" to run a DTS package from a stored
>>> procedure and used the /A parameter for passing user variables. How
>>> can i use the "SSIS" to build into the SQL2005 server a new package
>>> and run it from a stored procedure while passing user variables.
>>> thanks.
>>>