Search Options
Skip to main content (Press Enter).
Sign In
Skip auxiliary navigation (Press Enter).
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Communities
General Discussion
My Communities
Explore All Communities
Products
Solutions
Services
Developers
Champions Corner
Customer Stories
Insights
Customer Advocacy Program
Badge Challenges
Resources
Resource Library
Hitachi University
Product Documentation
Product Downloads
Partners Portal
How To
Get Started
Earn Points and Badges
FAQs
Start a Discussion
Profile
My Contributions
List of Contributions
Profile
Fiodar Hulin
This individual is no longer active. Application functionality related to this individual is limited.
Contact Details
×
Enter Password
Enter Password
Confirm Password
Fiodar Hulin
This individual is no longer active. Application functionality related to this individual is limited.
Profile
Connections
Contacts
Contributions
Badges
List of Contributions
My Content
1 to 3 of 3 total
search criteria =
ALL
RE: Pentaho MS-SQL set IDENTITY_INSERT a00 ON for table output
Posted By
Fiodar Hulin
03-06-2020 14:26
Found In
Community:
Pentaho
\
view thread
https://stackoverflow.com/questions/60438353/pentaho-ms-sql-set-identity-insert-a00-on-for-table-output/60510628#60510628 Same question - Idea of answer was to use job instead of transformation but problem is that SQL runs in OTHER session
Pentaho MS-SQL set IDENTITY_INSERT a00 ON for table output
Posted By
Fiodar Hulin
02-28-2020 09:11
Found In
Community:
Pentaho
\
view thread
Hi All PDI 9.0 Simple job MS SQL connection Table input -> tableouput tableouput table : CREATE TABLE [dbo].[a02]( [ProductID] [int] NOT NULL IDENTITY(1,1) .. I need to write IDENTITY explicitly in SSMS I run set IDENTITY_INSERT a00 ON and do insert ok. In pentaho I got error Table output.0 ...
Pentaho MS-SQL set IDENTITY_INSERT a00 ON for table output
Posted By
Fiodar Hulin
02-28-2020 09:11
Found In
Library:
Pentaho
© Hitachi Vantara LLC 2023. All Rights Reserved.
Powered by Higher Logic