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 |
|
rosejr
Starting Member
12 Posts |
 Posted - 2008-10-29 : 15:47:15
|
| The following query throws errors, saying "Syntax error or access violation". Are you able to use parameterized queries with IF statements like below or IF EXISTS?IF ( SELECT COUNT(*) FROM DBO.CASE_XREF WHERE ACCT_NBR = ? ) = 0 BEGINRAISERROR('Invalid PROD NB Acct_nbr', 16,1)ENDIf not does any one have any solutions? I trying to avoid using stored procs and keep all code in the DTS. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-10-30 : 06:33:00
|
| Why avoid using Stored Procs? Are you trying to slow the processing down for some reason?To do this in DTS, you will need to use an ActiveX script. |
 |
|
|
|
|
|
Using Parameterized Queries in DTS