Dynamic Propertie Task Error

• kdog

  SSC Veteran

  Points: 258

  More actions

  May 2, 2002 at 9:04 am

  #104818

  I have created a DTS package with a text to db transformation.

  Just before the task starts I have created a Dynamic Properties task, which does the following:

  Changes the path name of the physical location of the data text file using a SQL

  Here is the code:

  DECLARE @p1 nvarchar(60), @p2 nvarchar(50), @pathName varchar(250)

  SET @p1 = '\\HUMBOLDT73\ManagedCare\Shared\Payor Data\Load\BCBS\'

  SET @p2 = '\VIAMRS'

  PRINT @p1 + datename(yy, getdate()) + '\' + datename(m, dateadd(m, -1, getdate())) + @p2

  What I am trying to accomplish is to set the source path of the text file dynamically by specifying the Year and Month -1 in the path name.

  Here is how I have implemented the task:

  http://www.brady-family.net/images/DTS.gif

  Any help on how to implement this task using the Dynamic Property task would be great. Thanks Folks

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 2, 2002 at 11:04 am

  #428348

  Seems sound, does the path it barks about exist? I believe it tests for the validity and that is why you get the error.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)