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 |
|
srinivas.alwala
Starting Member
30 Posts |
 Posted - 2008-04-17 : 07:25:01
|
| Hi,While executing a task in DTS package I found an error as Invalid Pointer.SQL statement in Source of Transform Data Task Properties is :Delete From TableName Where column in (Select * from Table Where Condtion2)Select * from Tableand in Description field as :Copy Data From [DB].[dbo].[Table] to [DMIS].[dbo].[TableName] TaskDestination table is :TableNamePls let me know how to rectify this Error.Regards,Srinivas Alwala |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-17 : 07:58:33
|
| try making the source statementif 1=0 select * from TableDelete From TableName Where column in (Select * from Table Where Condtion2)Select * from TableYou would usually make the delete a seperate step. If you want to do more processing it's probably better to make it a stored procedure (I always try to make all sources SPs so that hte package isn't bound to the database structure) if you do this then you often have to use the above technique to use the desiner, it doesn't affect the runtime though (but it does with SSIS if you migrate).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Invalid Pointer Error using DTS Package