Search results for query: *

Thanks for all your help. I'm chuffed i can get it running at all - as was at the point of giving up. happy holidays! kirsty

Hi The tasks in the original 20 vary. One of the larger ones has 9 transform data task, 18 sql tasks and 9 vb script tasks. I've justtried altering the number of tasks executing in parallel - no joy i'm afraid. krn

It did when first migrated, but since then the mapi logins were changed to the one sqlagent uses, so when i run it now it doesnt complete. (My login on the live is not the same as the dba's so the email will work for one but not the other - getting full permission on the server is not an...

Hi Mutley The first 2 need to run in order and the 3rd and 4th after them on successful completion. So 3 and 4 can run in parallel, but havent been scheduled that way (mostly cos not sure the dev server would cope). Package 1 creates some snapshots of tables. package 2 imports data for lookup...

Hi Mutley1 The account on live does have all the relevant permissions - individually the 20 packages will all schedule and complete. Have had the odd Mapi error - but have those sorted now. One problem is that i have full admin rights on the dev server but not on the production server - so...

Thanks Mutley1 That worked a treat. If anyone knows why it was doing this i'd still love to know. krn

Hi All I'm hoping someone can help as this is driving me mad. I have a number of sql server 2000 DTS packages (20) which i have moved to a new server. All work perfectly on this server when scheduled. I have nested these packages into 4 master packages e.g. master package A contains packages...

Hi All I'm hoping someone can help as this is driving me mad. I have a number of sql server 2000 DTS packages (20) which i have moved to a new server. All work perfectly on this server when scheduled. I have nested these packages into 4 master packages e.g. master package A contains packages...

Hi All I have create some views in a SQL server 2000 database. The source tables and fields all have descriptions which i can access via information schema. What i'd like to be able to do is provide similar descriptive information for the views as for the base tables (e.g a description of...

thats great - thank you Any idea why an existing package has parsing problems but a new package doesnt? What do i need to set up inside the child package? anything? or is it all done in the execute package task? cheers krn

Hi All I have a master DTS package that has a global variable of 'gvImportDate'. The master DTS package executes other DTS packages (e.g. a DTS called ImportDetailTables). These packages contain a third level of DTS packages (e.g. ImportDetailTables contains ImportSkillDetails). I want to be...

Hi All I have a master DTS package that has a global variable of 'gvImportDate'. The master DTS package executes other DTS packages (e.g. a DTS called ImportDetailTables). These packages contain a third level of DTS packages (e.g. ImportDetailTables contains ImportSkillDetails). I want to be...