How to convert Dynamic property task in SSIS?

• guptaopus

  SSCommitted

  Points: 1534

  More actions

  November 24, 2007 at 6:18 am

  #184015

  Hi,

  I have DTS package which is passing query(given below) thru Dynamic property task to ActiveX script....Here value of [ ] value.

  "if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

  DROP TABLE [dbo].[ ]

  GO

  SELECT * INTO [dbo].[ ]

  FROM SG_POS_Template

  WHERE 1 = 0;

  GO"

  I have also attached activex code in this post .....please any body help me how to convert this in SSIS???

• Powichrowski Marek

  Hall of Fame

  Points: 3423

  More actions

  November 25, 2007 at 5:58 am

  #753808

  Right click on SSIS Packages and enter MIgrate DTS 2000 Package option.