Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kgnagaraj
Starting Member
3 Posts |
 Posted - 2005-06-09 : 02:54:35
|
| I am executing a DTS package (activex script) Using DTS and FTP to push files (Example given in SQL Team.com /Guest Author on 1/13/2003 in DTS).. and error message shows the following message after executing 2 steps (Step 1: setup for today and Step 2: Set New Destination) "The Data Pump Tasks Requires Transformations to be specified"if anyone knows pl. reply...asapthnx.... |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-06-09 : 04:47:29
|
| It sounds like your data pump task has no associated transformations(!) Do a disconnected edit and see if you can expand the transformations collection under your data pump task. Are you creating the data pump dynamically? |
 |
|
|
kgnagaraj
Starting Member
3 Posts |
Posted - 2005-06-09 : 06:25:59
|
| There was no property & value in transformations collection. |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-06-11 : 07:29:56
|
| At the risk of stating the obvious, the datapump needs transformations defined to accomplish anything useful. Are you creating the task dynamically in script at runtime?Mark |
|
|
|
|
|
|
Data Pump Tasks Reqrs Transformations to be spec.