How do I make transform data task dynamic SQL Server?

[shanghai2004]

Can somebody help me ?
I don't know How to make transform data task dynamic SQL server?

 

[dbomrrsm]

what exactly are you trying to do - more detail is needed

[blue]DBomrrsm[/blue]

 

[shanghai2004]

Thanks DBomrrsm
The following is the details of my question:
In data conversion, I need to load different data files to different tables
in a database. Instead of create one DTS package for each loading, I want to
create only one dynamic DTS package to do all.

 

[dbomrrsm]

you just have multiple connections from the sources to the destinations within one package. For example new DTS create a text file sourse and a SQL Server connection and a transform data task - set up as you would then do another text file sourse ETC ETC - all part of one DTS package.

You can even set them up so they dont interfere with each other i.e. after first table load do an on completion to the next table load.

Good luck.

[blue]DBomrrsm[/blue]

 

[shanghai2004]

I created a DTS package that has two connections, source text file1 and destination table2; and a task, transform data task. I add a dynamic properties task on the package and set two globle variables, gvtextfile and gvtable.
I expact that the dynamic properties task can allow me to use the package for text file2 and table2. Here table2 and table1 have total different structures. So do the file2 and file1. I set gvtextfile to textfile2 and gvtable to talbe2, the execute the package. I got error message. It said "field not found".
I think that the problem is the transformation is fixed. Can I make transformation as a globle variable?

Thanks

 

[yksvaan]

DataPump Task's transformation isn't that simple. Have a look at it with "Disconnected edit" (right-click package white-space).

I suggest that you create all the possible Transfer tasks in your package. Then with dynprop you can modify the steps of those tasks by changing steps property DisableStep , so that the package runs that time only the/those transfers you want.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]