Dude,

Right now I have that method only. Is there anyother way we can accomplish that task. The reason is even I create the database dynamically in the procedure (as part...

Greg,

Thanks. I got the solution.

This is the command to be added to attach files.

EXEC @hr = sp_OAMethod @iMsg, 'AddAttachment', @Err out,'C:\temp_ip.txt'

Greg,

When I clicked on the link , it is not taking me to the TOPIC. Can you just post me the reply.

Thanks

I think , I missing something here to explain in detail.

I just have only one task(ActiveX Script) in my package. I am creating a FileSystemObject and using that object ,...

I couldn't find any property like that in my DTS Tasks Disconnected Edit properties. Can you please explain me in detail, where can I find this property setting..

Thanks

I finally found the solution for this. It is explained very clearly in

Microsoft Knowledge Base Article - Q298725

Here is the breif explanation and resolution

SYMPTOMS

A Data Transformation Services (DTS) package...

This is the error message i am getting when i try to run the package from SQL job

Error Detail Records: Error: -2147220482 (800403FE);...

Here is the Continuation of the question.

The above code works fine when i run it from DTS package. But when I call the same DTS package from a Job ,...

Hi Dude,

Check this site, it worked for me...you can execute the DTS package from a stored procedure using OLE Stored Procedures.

http://www.sqldts.com/default.aspx?220,273,273,1,1

Hi Klaas,

I am using a Partioned view and if you look in detail part of the primary key column f1 got a check constraint in it. As for Microsoft the...

Hi Klas,

That is true, i want to know why query optimizer is not choosing the query plan to go and collect data only from Northwind when it is a composite...

Please look in to this code

Use Pubs

Go

Create table Balaji ( f1 int not null Primary key, f2 varchar(10) Not Null)

Go

Create table Balaji2 ( f1 int not null , f2 int...

OOPs ....Typo error . Disregard the previous one. Look in to this. Thanks

Use Pubs

Go

Create table Balaji ( f1 int not null Primary key, f2 varchar(10) Not Null)

Go

Create table Balaji2 (...