Running a local package

Is it possible to make a local package run everytime a record is saved to my
database?Hi
I am not sure what you mean by local package, but you could run a DTS
package run a trigger, although it may not be advisable. Depending on what
you really want to do, there may be some other method.
John
"johnfli" <john@.here.com> wrote in message
news:u8OqaWu4EHA.1392@.tk2msftngp13.phx.gbl...
> Is it possible to make a local package run everytime a record is saved to
> my
> database?
>|||I have a DTS package that is currently set every 30 min. that goes through
the database and any fields that has blank fields, it makes them NULL.
I was wondering if there was a way to have it run through and do that every
time a user enters in a new record.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:u2RPDtu4EHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi
> I am not sure what you mean by local package, but you could run a DTS
> package run a trigger, although it may not be advisable. Depending on what
> you really want to do, there may be some other method.
> John
> "johnfli" <john@.here.com> wrote in message
> news:u8OqaWu4EHA.1392@.tk2msftngp13.phx.gbl...
> > Is it possible to make a local package run everytime a record is saved
to
> > my
> > database?
> >
> >
>|||You could use Check Constraints to disallow empty strings. That would fail
the insert or update. The other option would be to code triggers that would
replace undesireable data.
Sincerely,
Anthony Thomas
"johnfli" <john@.here.com> wrote in message
news:%23%23$JCUv4EHA.2196@.TK2MSFTNGP14.phx.gbl...
I have a DTS package that is currently set every 30 min. that goes through
the database and any fields that has blank fields, it makes them NULL.
I was wondering if there was a way to have it run through and do that every
time a user enters in a new record.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:u2RPDtu4EHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi
> I am not sure what you mean by local package, but you could run a DTS
> package run a trigger, although it may not be advisable. Depending on what
> you really want to do, there may be some other method.
> John
> "johnfli" <john@.here.com> wrote in message
> news:u8OqaWu4EHA.1392@.tk2msftngp13.phx.gbl...
> > Is it possible to make a local package run everytime a record is saved
to
> > my
> > database?
> >
> >
>|||Hi
I think the best way to do this would be to change the insert statement to
use NULLIF(). Failing that you can use an instead of trigger to do the same
thing.
John
"johnfli" <john@.here.com> wrote in message
news:%23%23$JCUv4EHA.2196@.TK2MSFTNGP14.phx.gbl...
>I have a DTS package that is currently set every 30 min. that goes through
> the database and any fields that has blank fields, it makes them NULL.
> I was wondering if there was a way to have it run through and do that
> every
> time a user enters in a new record.
>
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:u2RPDtu4EHA.4028@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> I am not sure what you mean by local package, but you could run a DTS
>> package run a trigger, although it may not be advisable. Depending on
>> what
>> you really want to do, there may be some other method.
>> John
>> "johnfli" <john@.here.com> wrote in message
>> news:u8OqaWu4EHA.1392@.tk2msftngp13.phx.gbl...
>> > Is it possible to make a local package run everytime a record is saved
> to
>> > my
>> > database?
>> >
>> >
>>
>