May 2, 2002 at 9:04 am
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
May 2, 2002 at 11:04 am
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)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy