User profile for benhall

Hello, I think the issue you are experiencing is due to the way SQL Server handles committing the transaction. When in batch mode, we have multiple isolated transactions, because they only involve a small set of records you don't notice a delay when SQL commits the transaction. However, if you are not using batch mode, because of the amount of data your are processing, SQL Server takes longer to complete the transaction commit, which is why you are experiencing this. Out of interest, how long is the wait you are experiencing? Could I ask, why does batch mode not work for you? Thanks Ben / comments

Hello, I think the issue you are experiencing is due to the way SQL Server handles committing the transaction. When in batch mode, we have multiple isolated transactions, because they only involve...

0 votes

Hello, Sadly, there isn't a way to increase the size of the textbox on the manual foreign key generator. I've added a note into our system to look at improving in a future release. Thanks for reporting this. Ben / comments

Hello, Sadly, there isn't a way to increase the size of the textbox on the manual foreign key generator. I've added a note into our system to look at improving in a future release. Thanks for repor...

0 votes

Hi, Thanks for your post. Sadly, this currently is not possible, however it is something we will consider for the next main release. If you have any other feedback please let us know. Thanks Ben / comments

Hi, Thanks for your post. Sadly, this currently is not possible, however it is something we will consider for the next main release. If you have any other feedback please let us know. Thanks Ben

0 votes

Hello, I'm sorry you have encounted a problem, I haven't encounted this myself. Do you have any special applications handling your monitor support? You should be able to close the report using the cross in the right corner or using the menu icon in the left corner. Can you see the title bar? The shortcut Alt+F4 should close the window and return you to the SDG screen. Thanks Ben / comments

Hello, I'm sorry you have encounted a problem, I haven't encounted this myself. Do you have any special applications handling your monitor support? You should be able to close the report using the ...

0 votes

Hello, Are you using SDG 1.2? Does anything appear in the log file? Our generators are dependent on the version of SDG they are built against. I then to upload the updated versions related to our new release, sorry I have been a bit slow getting around to this. Thanks Ben / comments

Hello, Are you using SDG 1.2? Does anything appear in the log file? Our generators are dependent on the version of SDG they are built against. I then to upload the updated versions related to our...

0 votes

Hi Jay, We currently do not support this, however we have heard this multiple times and willl look at it for a future release. The only approach would be to write some SQL which would produce the required result, or create your own generator (possible which could interact with the existing weighted list generator, not sure if this is possible - sorry.). If you have any other feedback, or need any other help please let us know. Thanks Ben / comments

Hi Jay, We currently do not support this, however we have heard this multiple times and willl look at it for a future release. The only approach would be to write some SQL which would produce the r...

0 votes

With the SQL Statement generator, by default we shuffle the data, by unticking shuffle data the data will be inserted in the same order it appears in the database. Hope this helps. Ben / comments

With the SQL Statement generator, by default we shuffle the data, by unticking shuffle data the data will be inserted in the same order it appears in the database. Hope this helps. Ben

0 votes

Hello, I recommend you to use the SQL Statement generator as this will shuffle the data for you. You should be able to mix and match the SQL Statement Generator with the Map functionality, allowing you to only shuffle the columns you are interested in. I hope this helps. Ben / comments

Hello, I recommend you to use the SQL Statement generator as this will shuffle the data for you. You should be able to mix and match the SQL Statement Generator with the Map functionality, allowin...

0 votes

Hi David, I just created the following table and that all appears to work as expected. CREATE TABLE TempTable(ID INT, Address varchar(100) NOT NULL, Destination varchar(1000) NOT NULL) Would it be possible for you to send me your schema and project file so I can attempt to reproduce this on my local machine. Which SQL Server version are you running? Thanks Ben / comments

Hi David, I just created the following table and that all appears to work as expected. CREATE TABLE TempTable(ID INT, Address varchar(100) NOT NULL, Destination varchar(1000) NOT NULL) Would it be ...

0 votes

Hi, Thanks for your post. Sorry you have encountered this problem. In order for me to produce this, what are the datatypes of the two columns? Is your regex expression something like $[Address] ? Thanks Ben / comments

Hi, Thanks for your post. Sorry you have encountered this problem. In order for me to produce this, what are the datatypes of the two columns? Is your regex expression something like $[Address] ? T...

0 votes

How can we help you today?

benhall

Comments