How to move some tables with data & procedures etc from 1 database to another in sql server 2005 express edition.
i did by scripting but i transfer tables and procedures and not data
data is the problem.
tnx
I'm already discussing this with you here
http://forums.asp.net/thread/1299924.aspx
sqlGreetings all,
After moving all my packages to a new server, win2K3, SQL2k5, non of the SSIS packages run. They all ran fine on the other server.
The error is
"2006-03-07 13:09:38 - ! [LOG] Step 1 of job 'ExportXML' (0x4E0C7495EFE4034FA6EF94B7C7F77262) cannot be run because the SSIS subsystem failed to load. The job has been suspended"
These packages ran perfectly on the old system.
Running the package manually, using DTExec or from the Saved Packages tree in SQL is fine.
Package is saved in SQL.
Any ideas?
Do you have SSIS installed on that machine?
This isn't meant to be as patronising as it sounds, honest. 
Its just that some people think installing BIDS constitutes installing SSIS and that isn't the case.
-Jamie
|||Since your package works on the new server using DTExec (and the error indicates an agent subsystem failed to load) you might want to post this question to the agent forum since it sounds like an agent problem not an SSIS problem.
Thanks,
Matt
|||Jamie,
It is installed.
I can run packages saved in msdb usiing dtexec with no problem.
Will post on the Agent group and see. Only a couple people had this problem it would seem.
Cheers,
