DTS package

• PB-209154

  SSC-Addicted

  Points: 462

  More actions

  February 15, 2005 at 9:47 pm

  #85470

  Hi all

  I want to create a DTS package that runs on a stored procedure which accepts parameters. This is important to avoid any hard coding of values in stored procedure.

  Question 1. Is it possible to prompt the user for parameter values when running DTS package? Currently, I am using Execute SQL Task and Global variables to do it. Is there an alternative?

  Question 2. My DTS package runs for a varchar type of parameter but gives an error when passing an int type variable to the stored procedure. How can I solve this?

  Question 3. The DTS package gives a message of successful execute and records no errors in the logs, But it does not perform the transfer of data. What could be wrong?

  This is the stored procedure I am using:-

  CREATE PROCEDURE proc1 @v1 varchar(50)

  AS

  INSERT INTO destiTable SELECT * FROM sourceTable WHERE column1 = @v1

  Thanks everyone!!

• philcart

  SSC-Forever

  Points: 47796

  More actions

  February 15, 2005 at 10:34 pm

  #542441

  Please don't cross post.

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=161925

  

   

  --------------------
  Colt 45 - the original point and click interface