Can Triggers inititate an SSIS package run?

All:

I have a need to initiate an SSIS package based upon additions/changes that would be made to a db table. Can this be done and if so how?

Thanks!

Sure. Use xp_cmdshell to call dtexec.exe. Or, set up a SQLAgent job and call it using sp_start_job.

-Jamie

|||

Thanks Jamie! I have never worked with Triggers before but will give your solution a shot.

|||

Begin: (Stupid Question)

Where do I find sp_start_job

End;

|||Found it in msdb database. Thanks!

can objects in sql server change your nt login password

hi guys,
i was wondering if there is a bug in sql server 2000 that upon changing settings in the sqlserver agent or sqlserver services that it will actually change your nt user password.
a strange occurence happened to me i switched the sqlmail to a different outlook profile that is MAPI compliant i had to stop and start the sql server agent upon restart it said it could not log me in b/c my nt logon failed (i guess you can figure out by now that i have authentication as NT in my set up of sql server agent). well me knowing microsoft products i was like ah i will just reboot the machine) well upon reboot my administrator password which is empty "null value"no longer is valid.
now noone in the company said that they changed the administrator password and it is not logged into a domain so the machine is not on our companys network. we log in local to the machine as the administrator. the last things that i played around in with sql server was replication setting it up as a publisher and deleteing it and changing a mapi profile. is there anywhere in sql 2000 that messing with any setting that it will actually affect your windows nt user login?? i know i cant be loosing my mind here and i hope someone at my company wouldnt sabotage my machine. right now i have two options i can reinstall win 2000 and choose repair hoping that i will not lose my sql 2000 info or i can try a password cracker. any suggestions that might of cause this to happen?
regards,
Robertof course Microsoft is always providing use with new features, but I doubt this unlikely. What you described sounds exactly as if the user password had been changed at the OS level. The password could have been changed by mistake.

can not load xpstar.dll

hi,
i have sql server sp3 running upon win 2000 adv server sp 4. the server is
configured for merge replication with another machine with same
configuration (sql server sp3 running upon win 2000 adv server sp 4). few
days back i recieved this error when i was trying to connect SQL server
remotely from one macine to the other.
Microsoft SQL-DMO(ODMC SQL State:42000) Error 0: cannot load the dll
xpstar.dll, or one of the DLLs it refferences. Reason: 126(the specified
module could not be found)
even if i could connect, i get the same error upon almost every activity on
the remote sql server. i found no reasonable solution to the problem on the
internet. finnally i uninsalled the sql server and then installed fresh sql
server and sp3. the problem was resolved. but afetr few days, i m facing
the same problem back again. i have repeated the same course of action.
i need to know any why this is happning so i could reach to the root of the
problem. installing back the sql server is not an optimal solution. need
help and fast.
thanx in advance.
Atif Chowhan
When you check you will find that xpstar.dll is actually there and loaded. The file missing is probably shfolder.dll. This folder resides in %systemRoot%\system32, copy it from any other server.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

can not load xpstar.dll

hi,
i have sql server sp3 running upon win 2000 adv server sp 4. the server is
configured for merge replication with another machine with same
configuration (sql server sp3 running upon win 2000 adv server sp 4). few
days back i recieved this error when i was trying to connect SQL server
remotely from one macine to the other.
Microsoft SQL-DMO(ODMC SQL State:42000) Error 0: cannot load the dll
xpstar.dll, or one of the DLLs it refferences. Reason: 126(the specified
module could not be found)
even if i could connect, i get the same error upon almost every activity on
the remote sql server. i found no reasonable solution to the problem on the
internet. finnally i uninsalled the sql server and then installed fresh sql
server and sp3. the problem was resolved. but afetr few days, i m facing
the same problem back again. i have repeated the same course of action.
i need to know any why this is happning so i could reach to the root of the
problem. installing back the sql server is not an optimal solution. need
help and fast.
thanx in advance.
Atif ChowhanWhen you check you will find that xpstar.dll is actually there and loaded. The file missing is probably shfolder.dll. This folder resides in %systemRoot%\system32, copy it from any other server.
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.