Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kleinklausi
Starting Member
2 Posts |
 Posted - 2005-07-11 : 11:18:56
|
| Hi,I've got a strange error message when I try to use an ExecutePackageTask within an DTS-Package. This error only comes up, when the Package is scheduled and owned by 'sa'. When I execute the package manually, everything works fine. (I use outer global variables.)Any Ideas?Thanks in advance, MoritzStep Error Source: Microsoft Data Transformation Services (DTS) PackageStep Error Description:Type mismatch.Type mismatch.Step Error code: 80020005Step Error Help File:sqldts80.hlpStep Error Help Context ID:1100 |
|
|
kleinklausi
Starting Member
2 Posts |
Posted - 2005-07-12 : 06:35:57
|
| hi,I figured out the problem:The package B which is executed by package A have some global variables of type 'Date'.The package B was designed in an german environment and the value for the global variable was "01.01.1900".But the Scheduler runs under the 'sa' account, which takes usually an english environment.When the scheduler execute the package B, he tries to cast "01.01.1900" into a Date value.You have to use the same environment to design the package or to leave out global variables with type Date.by |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-07-12 : 06:41:29
|
| Afrikaans or Dutch? |
|
|
|
|
|
|
Error: "Type mismatch" using ExecutePackageTask