 | |
Processing AS task
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Processing AS task -
06-24-2004
, 07:35 AM
#2
| |||
| |||
|
|
How come it doesn't tell me if something goes wroing in AS ? The package just looks as is it is till running. When doing the same thing directly in AS i get error information. |
#3
| |||
| |||
|
|
Have you set up logging? Does this task and all that touch her execute on the main package thread? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:%23SCbXceWEHA.3284 (AT) TK2MSFTNGP12 (DOT) phx.gbl... How come it doesn't tell me if something goes wroing in AS ? The package just looks as is it is till running. When doing the same thing directly in AS i get error information. |
#4
| |||
| |||
|
|
Nope to logging ... And come again to the second part...? If you mean that a main package must not call a subpackage with processing then that could be the problem - i have gathere my processing in a sub-package....will try to move these to the main package. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> skrev i en meddelelse news:%237uWtheWEHA.1756 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Have you set up logging? Does this task and all that touch her execute on the main package thread? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:%23SCbXceWEHA.3284 (AT) TK2MSFTNGP12 (DOT) phx.gbl... How come it doesn't tell me if something goes wroing in AS ? The package just looks as is it is till running. When doing the same thing directly in AS i get error information. |
#5
| |||
| |||
|
|
No it is not necessarily the "Sub Package" part. Try having all steps in all Package execute on the main thread. -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:%23wtMhzeWEHA.3988 (AT) tk2msftngp13 (DOT) phx.gbl... Nope to logging ... And come again to the second part...? If you mean that a main package must not call a subpackage with processing then that could be the problem - i have gathere my processing in a sub-package....will try to move these to the main package. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> skrev i en meddelelse news:%237uWtheWEHA.1756 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Have you set up logging? Does this task and all that touch her execute on the main package thread? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:%23SCbXceWEHA.3284 (AT) TK2MSFTNGP12 (DOT) phx.gbl... How come it doesn't tell me if something goes wroing in AS ? The package just looks as is it is till running. When doing the same thing directly in AS i get error information. |
#6
| |||
| |||
|
|
Not sure how to do that... However - moving the tasks to the main package did the trick..... "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> skrev i en meddelelse news:%23m7rq$eWEHA.556 (AT) tk2msftngp13 (DOT) phx.gbl... No it is not necessarily the "Sub Package" part. Try having all steps in all Package execute on the main thread. -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:%23wtMhzeWEHA.3988 (AT) tk2msftngp13 (DOT) phx.gbl... Nope to logging ... And come again to the second part...? If you mean that a main package must not call a subpackage with processing then that could be the problem - i have gathere my processing in a sub-package....will try to move these to the main package. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> skrev i en meddelelse news:%237uWtheWEHA.1756 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Have you set up logging? Does this task and all that touch her execute on the main package thread? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:%23SCbXceWEHA.3284 (AT) TK2MSFTNGP12 (DOT) phx.gbl... How come it doesn't tell me if something goes wroing in AS ? The package just looks as is it is till running. When doing the same thing directly in AS i get error information. |
#7
| |||
| |||
|
|
The AS task is written in VB therefore it must always run on the main package thread due to threading limitations in VB. The task itself will always be set to execute on main thread, but task that talk to it, such as the Dynamic Properties Task, or tasks that call it through a child package, such as the Exec Pkg Task, must also be manually set to execute on main thread. Right-click the task, select Workflow Properties, Options. -- Darren Green http://www.sqldts.com "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:uRYetFfWEHA.644 (AT) tk2msftngp13 (DOT) phx.gbl... Not sure how to do that... However - moving the tasks to the main package did the trick..... "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> skrev i en meddelelse news:%23m7rq$eWEHA.556 (AT) tk2msftngp13 (DOT) phx.gbl... No it is not necessarily the "Sub Package" part. Try having all steps in all Package execute on the main thread. -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:%23wtMhzeWEHA.3988 (AT) tk2msftngp13 (DOT) phx.gbl... Nope to logging ... And come again to the second part...? If you mean that a main package must not call a subpackage with processing then that could be the problem - i have gathere my processing in a sub-package....will try to move these to the main package. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> skrev i en meddelelse news:%237uWtheWEHA.1756 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Have you set up logging? Does this task and all that touch her execute on the main package thread? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:%23SCbXceWEHA.3284 (AT) TK2MSFTNGP12 (DOT) phx.gbl... How come it doesn't tell me if something goes wroing in AS ? The package just looks as is it is till running. When doing the same thing directly in AS i get error information. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.