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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-03 : 08:45:51
|
| Phil writes "We recently installed SQL Server Service Pack 3 on our database servers and now our DTS packages will not run. I went in and tried to create a new package and when I tried to set up a new global variable I get the following message:Could not convert variable gCount from type BSTR to type Int.Is there a solution for this?" |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2003-02-03 : 14:49:58
|
| I've had MS working on it since this morning. I'll let you know what they say..Thanks,JamesH. |
 |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2003-02-03 : 16:01:12
|
| Still not much although if you insert a Value into the 'Value' column of the global variable then you should be okay. I would double check though as I've seen inconsistent results whereas that original value has actually become static although it should just be an initialization value. Let me know what you find out.Thanks,JamesH. |
|
|
|
|
|
|
Sql Server 2000 with Service Pack 3 and DTS