Thanks julie my problem got solved.

Ramesh

Hi julie,

When i run package with all the above options i am getting an error that is msdtc service is not available, if i unselect join transaction if present, roll...

Hi Julie,

Thanks a lot, it really worked out. Once again thanks for your help.

Ramesh

Hi Anthares,

Thanks for your reply, i tried it before writing to forums but it doesn't work out . i selected "Use transactions" and "commit on successful package completion". I do...

Hi,

Can any one explain how to save with SaveToRepository option using transact sql i tried in the following way but it is not wrking out.

Exec @hr = sp_OAMethod @obj,

'SaveToRepository',

@RepositoryServerName =...

Hi,

For creating a dts package we are following

exec @hr = sp_OACreate "DTS.package"

If at we need to to store it to meta data services what should we do.

Thanks

Ramesh

Thanks friends with slight modifications it worked out. I will post entire script soon.

Hi Phill Carter,

Thanks for sparing your valuable time. I saved it as a procedure and executed. The script was with minor changes.pls find it below.

create procedure dtsimport as

declare @hr int...

Hi Russel,

Thanks for sparing time for this, my problem is this should be executed at client database server whrere only sql available. If you can suggest some commands or script...

Hi russel,

Thanks for your response, but this to be achieved by back end scripts only.

Thanks

Ramesh

Hi noel,

Thanks for your reply, you are very close to my requirement. coluld you pls explaine me in detail how to achieve it by sp_add_dtspackage. I am unaware of obeject...

Hi julie,

Thanks for you help, but my requirement is through command line only that can be either tsql or bcp or some thing else. i am new to sql server...

Hi Julie,

Thanks for your response. i need it without using activex. Purely with sql server utilities.

Thanks

Ramesh