I am creating a DTS package to import from a txt file (YYYYMMDD.TXT)
to a table in SQL 2000 Database.

Here are the steps I am using:

1. I create my package using file 20050314.txt as source. It works
fine.

2. Next, I add global variable "MYFile".

3. I add Dynamic Property task and assign property "SourceObjectName"
the
value "MyFile"

4. I add Workflow, On Success to link the Dynamic Properties Task to
the Source Object.

5. When I run this DTS from the stored procedure using the /A switch
it still imports the test file 20050314.txt (No errors)

I am using the syntax:

set @MyStr = 'dtsrun /Sx /Nx /Ux /Px /AMyFile=' + @FilePath
exec master..xp_cmdshell @MyStr

-- @FilePath = full-path of the txt file


PLEASE HELP!

You want to change the DataSource property of the Text File connection



"Jayesh Shah" <jayeshm53 (AT) hotmail (DOT) com> wrote