Re: Passing Parameters to a dts package

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Allan,

Thanks a lot for these info. I am going to try this and get back to you.

Thanks again.
Suhas


"Allan Mitchell" wrote:

> A quick and simple way is to build your SQLStatement like this
>
> Global Variables and SQL statements in DTS
> (http://www.sqldts.com/default.aspx?205)
>
> You can then pass in the values of the variables to the package using DTSRUN
> and the /A switch.
>
>
> OR
>
>
> depending how you call the package you could set the SQL Statement using the
> object model through code.
>
>
> OR
>
>
> You could use the first suggestion but have the package look up the values
> in a SQL Server table using the Dynamic Properties task.
>
>
>
>
>
> "Suhas Vengilat" <SuhasVengilat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:48247E37-95E9-444D-9DAA-D52ADDE9D433@xxxxxxxxxxxxxxxx
> > Hi,
> >
> > Is is possible to pass parameters to dts package, that we need to run
> > using
> > dtsrun. I have a query like - select a,b,c from table where id in
> > ('x','y').
> > We need to parameterise the 'in' CLAUSE. What is there in the 'in' CLAUSE
> > can
> > be more than I have given and it frequently changes. Could someone give a
> > solution for this.
> >
> > Thanks in Advance
> > Suhas
> >
>
>
>
.