Results 1 to 2 of 2

Thread: CREATE VIEW access

  1. #1
    sav is offline Junior Member
    Join Date
    Jul 2013
    Rep Power

    CREATE VIEW access

    We are using MS SSIS Teradata Connector v1.2 to retrieve data from a couple of TD views via select statement by MS SQL Server Integration Service Package build in Visual Studio 2008. All works fine, but TPT tries to CREATE VIEW in TD DB and fails.
    “Failed to create a view for metadata tertival… The user does not have CREATE VIEW access to database XXXXXX”.

    So, the questions are:
    1. Why the connector CREATES VIEW in TD DB? May be it is obligatory by TD and not Attunity? Why just not simply use «type» statement to retrieve metadata?
    2. Where should I change a value property to avoid creating of any new objects in TD?

  2. #2
    JPQuinn is offline Junior Member
    Join Date
    Feb 2017
    Rep Power

    SSIS Extract Package Creating Illegal Views on Teradata in Background


    We too have this same CREATE VIEW by SSIS issue using Attunity to Teradata.
    *We’ve got a weird thing happening and I wanted to run it past you for thoughts and ideas. We have several times a day, an Attunity provider/Teradata driver connection to Teradata, where we execute a Select statement query to extract data to the SQL Server been running about 1.5 years now.

    **We only extract data and its always done via a query with a select, we do not CREATE/REPLACE tables or views or exec procs, etc So I get notified by a Teredata DBA telling us that about 100 times day, for quite some time, our Logon ID used by the SQL Server fails to create views due to lack of privileges.

    **We are not creating views, and when he gave us a sample script, we are now thinking that there some background service that SQL Server may be doing like creating a temp dynamic DateNamed view when it connects to pull that data through, then dissolves when completed.

    **Views it created in code that he gave us that we did not code into the SSIS package: CREATE VIEW SSIS_20170726122537_994 AS ( Sel…

    **Please let me know if my hunch is right, and what we can do about that, or, if Teradata is going to need to learn how to deal with the ID needing to create the temp view from SQL Server.


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts