Thank you Allen,

I will give this a try.

Peter

Thank you Allen, I will let you know how it worked!, Pete

Hi Allen and thank you for the reply. I'm aware of this command on a single table, but is there a way to execute this command with all of...

Hi Steve,

I just spoke to the systems administrator and he failed to install SP3.

Thanks for your help,

Pete

Knowone has come across this situation?

Anyone?

Thanks..:)

Frank, the following is an example of both code and result set

SELECT DISTINCT *

FROM CDSCTM_M B

WHERE NOT EXISTS

(SELECT *

...

Phillcart,

Thank you for your help. Since I'm not all familiar with Visual Basic, I opt to use the RAISERROR approach. My stored procedure is testing for the counts...

With VB Script, how can I pass values from SQL Server to VB Script? Basically, I would like the package to end IF the counts from (table a) do...

I'm using the Execute SQL Task

Also,

I forgot to mention that I'm receiving errors on my GOTO statements too. And like the other error, this code works in SQL Query Analyzer.

Peter

Hi Gabor,

This worked excellent, thank you. Now I need to truncate the remainder of the numbers to the right of the decimal. Is there a specific function in...

Hi Keith,

Thank you for the info. I'm not sure what value to put into the 'Data Link Properties' when I right click on the Data Source name and click...

Hi Keith,

Where can I find the extended propertied for the connect string?

Thanks,

Peter

Yes, there are 2 packages that populate 2 tables, one in test and the other in production.

I wrote the IF statement in the execute SQL task. I'm unsure how...

Frank,

This update statement worked perfectly.

Thank you for all your help.

Peter