Issues when importing Structures into DDT

Author Message
 Posted 1/28/2011 1:04:56 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 9/6/2013 3:34:52 AM
Posts: 29, Visits: 128
Hi,

We have imported a database structure into the DDT and we noticed that all fields which datatype is decimal were imported as INT.
This can be shown in the attached screenshot.

As also can be noted, the precision and scale values were noted by the DDT, however, the textbox is greyed out.

When we have deployed the package to create a new database, the field was created as INT.

Is there a fix for this issue?
Any feedback is appreciated

Thanks
Melvin

 InvalidInt.png (17 views, 23.67 KB)

Tags:
Post #29462
Add to Twitter Add to Facebook
 Posted 1/28/2011 7:24:06 AM
Strategic Support Team Member

Strategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team Member

Group: StrataFrame MVPs
Last Login: 2/26/2021 10:30:31 PM
Posts: 1,920, Visits: 21,166
Hi Melvin.

Where are you importing from? I have just tested it over here importing from a SQL Server database and it worked fine. The import procedure is certainly a feature to help on the DDT project creation, so if you still are getting this behavior, let us know from where you are importing and maybe just change the fields' data types on DDT after the import procedure so you can deploy your database correctly.
Post #29465
Add to Twitter Add to Facebook
 Posted 2/1/2011 5:47:05 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 9/6/2013 3:34:52 AM
Posts: 29, Visits: 128
Hi Ivan,

We are importing from an SQL Server 2005. To correct my previous post, the data type of the columns which are being imported are 'numeric' and not decimal. Could this be the reason?

Thanks,
Melvin
Post #29492
Add to Twitter Add to Facebook


Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.