Focal Point
[SOLVED by case] DataMigrator - Create New Target/Table

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6297064206

April 20, 2011, 10:23 AM
Nan
[SOLVED by case] DataMigrator - Create New Target/Table
Hi,

I am creating a data flow that polls a source table. I want to create the target table during the initial transfer. Thus created a new target and specified the target DB parameters and the new table name to be created. The agent crashes at runtime. What am I missing.

Thanks much for your help.

This message has been edited. Last edited by: Kerry,
April 21, 2011, 04:15 AM
FrankDutch
could be anything

-*what db format should the target be ?
-*do you have enough rights on the platform you want to use
-*what error message do you get
-*if you do a test, does it show anything

did you do this before and did that work?

try using a focus format file and see if that works




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

April 27, 2011, 11:32 AM
Nan
Sorry for the delayed response.

I had opened a case and it was a bug --> some of my source fields were 4000V and the current version 7.7.01 that we are using does not support it. The max can be only upto 32KB.