"VS_ISBROKEN" error

[DTS.Pipeline] Error: "component "Source - Query" (1)" failed validation and returned validation status "VS_ISBROKEN".

I'm getting this error in the Data Flow task when exexuting this sql:

SELECT * FROM tbl_ws_stats WHERE pk > pk_var

pk_var is a package variable which I confirmed is being set correctly. The sql is set as a property expression.

What could be causing this?

using SQL Server 2005

Thanks

What is your property expression? it should be something like:

"SELECT * FROM tbl_ws_stats WHERE pk > " + (DT_STR, 100, 1252)@.[pk_var]

-Jamie

|||Verify that you have a good connection to your database. I check by running a simple query in the "lookup" transform. You can also verify with the connection manager.

I routinely see this error when my Oracle listener is down.

% disktime

In NT4 this counter returned a value between 0 and 100. In 2000, the number
exceeeds 100. What is it acuatlly counting and why would a percentage stat
return more than 100?
I find that counter to be basically useless these days. I prefer the avg and
current disk queues for an indication of activity ove rthat.
Andrew J. Kelly SQL MVP
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:F7733806-7CB4-4D43-B20A-0F0E5AA6AAD2@.microsoft.com...
> In NT4 this counter returned a value between 0 and 100. In 2000, the
> number
> exceeeds 100. What is it acuatlly counting and why would a percentage
> stat
> return more than 100?
|||http://support.microsoft.com/default...310067&sd=tech
"Jeffrey K. Ericson" wrote:

> In NT4 this counter returned a value between 0 and 100. In 2000, the number
> exceeeds 100. What is it acuatlly counting and why would a percentage stat
> return more than 100?
|||click on the properties for that counter, your vertical scale is probably not
set to 100
"Jeffrey K. Ericson" wrote:

> In NT4 this counter returned a value between 0 and 100. In 2000, the number
> exceeeds 100. What is it acuatlly counting and why would a percentage stat
> return more than 100?

% disktime

In NT4 this counter returned a value between 0 and 100. In 2000, the number
exceeeds 100. What is it acuatlly counting and why would a percentage stat
return more than 100?I find that counter to be basically useless these days. I prefer the avg and
current disk queues for an indication of activity ove rthat.
Andrew J. Kelly SQL MVP
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:F7733806-7CB4-4D43-B20A-0F0E5AA6AAD2@.microsoft.com...
> In NT4 this counter returned a value between 0 and 100. In 2000, the
> number
> exceeeds 100. What is it acuatlly counting and why would a percentage
> stat
> return more than 100?|||http://support.microsoft.com/defaul...;310067&sd=tech
"Jeffrey K. Ericson" wrote:

> In NT4 this counter returned a value between 0 and 100. In 2000, the numb
er
> exceeeds 100. What is it acuatlly counting and why would a percentage sta
t
> return more than 100?|||click on the properties for that counter, your vertical scale is probably no
t
set to 100
"Jeffrey K. Ericson" wrote:

> In NT4 this counter returned a value between 0 and 100. In 2000, the numb
er
> exceeeds 100. What is it acuatlly counting and why would a percentage sta
t
> return more than 100?

% disktime

In NT4 this counter returned a value between 0 and 100. In 2000, the number
exceeeds 100. What is it acuatlly counting and why would a percentage stat
return more than 100?I find that counter to be basically useless these days. I prefer the avg and
current disk queues for an indication of activity ove rthat.
--
Andrew J. Kelly SQL MVP
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:F7733806-7CB4-4D43-B20A-0F0E5AA6AAD2@.microsoft.com...
> In NT4 this counter returned a value between 0 and 100. In 2000, the
> number
> exceeeds 100. What is it acuatlly counting and why would a percentage
> stat
> return more than 100?|||http://support.microsoft.com/default.aspx?scid=kb;en-us;310067&sd=tech
"Jeffrey K. Ericson" wrote:
> In NT4 this counter returned a value between 0 and 100. In 2000, the number
> exceeeds 100. What is it acuatlly counting and why would a percentage stat
> return more than 100?|||click on the properties for that counter, your vertical scale is probably not
set to 100
"Jeffrey K. Ericson" wrote:
> In NT4 this counter returned a value between 0 and 100. In 2000, the number
> exceeeds 100. What is it acuatlly counting and why would a percentage stat
> return more than 100?