With all due respect to Kishore&#39;s answer, that approach is valid if you&#39;re modifying the packages. Since you&#39;re using the import/export wizard, the more straight forward approach would be to check the `Enable Identity Insert` box on the Column Mappings tab.

In the Import Export Wizard, after selecting the table for copy, click the `Edit Mappings...` button

![enter image description here][1]

In the resulting screen, click the `Enable identity insert` property and your identities will be replicated over. 

![enter image description here][2]

Same net result as issuing `SET IDENTITY_INSERT TableName ON` &amp; OFF but this is done automagically at build time.

  [1]: http://i.stack.imgur.com/w0wVL.png
  [2]: http://i.stack.imgur.com/a5pHb.png

Before Importing date execute the below query to set identity insert on:

    SET IDENTITY_INSERT TableName ON


Then do the import operations.

After importing date execute the below query to set identity insert off:

    SET IDENTITY_INSERT TableName OFF

How to set up autolayout in Interface Builder to arrange views vertically as shown on image:

![scheme][1]

`Top view` pinned to top screen edge, `Bottom view` pinned to bottom screen edge. `My view` should be centered between top and bottom views (so distance to `Top view` equals to distance to `Bottom view`)

  [1]: http://i.stack.imgur.com/Rntb2.jpg

iOS autolayout to center my view between two views

I have a Play Framework application and I *was* using Hibernate 4.2.5.Final (which is retrieved via the Maven dependency manager).  I decided to upgrade to Hibernate 4.3.0.Final, recompile my application successfully, and ran it.

I got the exception below, and haven&#39;t been able to figure out why.  I downgraded back to 4.2.5 and this issue did not occur.  I then, tried upgrading Hibernate with each Final release after 4.2.5.  That is, I went from 4.2.5.Final to 4.2.6.Final, to 4.2.7.Final, to 4.2.8.Final and then to 4.3.Final.  The issue does not occur until I upgrade to 4.3.0.Final.

**Java version information**
    
    java version &quot;1.7.0_45&quot;
    Java(TM) SE Runtime Environment (build 1.7.0_45-b18)
    Java HotSpot(TM) 64-Bit Server VM (build 24.45-b08, mixed mode)

**And exception**:

    play.api.UnexpectedException: Unexpected exception[NoSuchMethodError: javax.persistence.Table.indexes()[Ljavax/persistence/Index;]
        at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1$$anonfun$1.apply(ApplicationProvider.scala:152) ~[play_2.10.jar:2.2.1]
        at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1$$anonfun$1.apply(ApplicationProvider.scala:112) ~[play_2.10.jar:2.2.1]
        at scala.Option.map(Option.scala:145) ~[scala-library.jar:na]
        at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1.apply(ApplicationProvider.scala:112) ~[play_2.10.jar:2.2.1]
        at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1.apply(ApplicationProvider.scala:110) ~[play_2.10.jar:2.2.1]
        at scala.util.Success.flatMap(Try.scala:200) ~[scala-library.jar:na]
    Caused by: java.lang.NoSuchMethodError: javax.persistence.Table.indexes()[Ljavax/persistence/Index;
        at org.hibernate.cfg.annotations.EntityBinder.processComplementaryTableDefinitions(EntityBinder.java:936) ~[hibernate-core-4.3.0.Final.jar:4.3.0.Final]
        at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:781) ~[hibernate-core-4.3.0.Final.jar:4.3.0.Final]
        at org.hibernate.cfg.Configuration$MetadataSourceQueue.processAnnotatedClassesQueue(Configuration.java:3762) ~[hibernate-core-4.3.0.Final.jar:4.3.0.Final]
        at org.hibernate.cfg.Configuration$MetadataSourceQueue.processMetadata(Configuration.java:3716) ~[hibernate-core-4.3.0.Final.jar:4.3.0.Final]
        at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1410) ~[hibernate-core-4.3.0.Final.jar:4.3.0.Final]
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1844) ~[hibernate-core-4.3.0.Final.jar:4.3.0.Final]

NoSuchMethodError in javax.persistence.Table.indexes()[Ljavax/persistence/Index

I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server import/export wizard and I went through the following actions:-

1. for the destination I chose &quot;SQL server native client 10&quot;.

2. then I selected copy data from one or more tables or view.

3. SSIS run immediately

but i got the following errors, 

&gt; Operation stopped...
&gt; 
&gt; - Initializing Data Flow Task (Success)
&gt; 
&gt; 
&gt; - Initializing Connections (Success)
&gt; - Setting SQL Command (Success)
&gt; 
&gt; 
&gt; - Setting Source Connection (Success)
&gt; 
&gt; 
&gt; - Setting Destination Connection (Success)
&gt; 
&gt; 
&gt; - Validating (Error)
&gt; 
&gt; Messages Error 0xc0202049: Data Flow Task 1: Failure inserting into
&gt; the read-only column &quot;ActionID&quot;.  (SQL Server Import and Export
&gt; Wizard)  
&gt; 
&gt; Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.
&gt; (SQL Server Import and Export Wizard)  
&gt; 
&gt; Error 0xc004706b: Data Flow Task 1: &quot;component &quot;Destination -
&gt; AuditActions&quot; (22)&quot; failed validation and returned validation status
&gt; &quot;VS_ISBROKEN&quot;.  (SQL Server Import and Export Wizard)

It seems that I can not import identity columns and timestamps columns, so how I can force these values to be imported?

Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column

I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server import/export wizard and I went through the following actions:-
<ol>
<li>
for the destination I chose "SQL server native client 10".
</li>
<li>
then I selected copy data from one or more tables or view.
</li>
<li>
SSIS run immediately
</li>
</ol>
but i got the following errors,
> Operation stopped...
>
> - Initializing Data Flow Task (Success)
>
>
> - Initializing Connections (Success)
> - Setting SQL Command (Success)
>
>
> - Setting Source Connection (Success)
>
>
> - Setting Destination Connection (Success)
>
>
> - Validating (Error)
>
> Messages Error 0xc0202049: Data Flow Task 1: Failure inserting into
> the read-only column "ActionID". (SQL Server Import and Export
> Wizard) 
>
> Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.
> (SQL Server Import and Export Wizard) 
>
> Error 0xc004706b: Data Flow Task 1: "component "Destination -
> AuditActions" (22)" failed validation and returned validation status
> "VS_ISBROKEN". (SQL Server Import and Export Wizard)
It seems that I can not import identity columns and timestamps columns, so how I can force these values to be imported?

I want to insert data into my table, but insert only data that doesn&#39;t already exist in my database.

Here is my code:

    ALTER PROCEDURE [dbo].[EmailsRecebidosInsert]
      (@_DE nvarchar(50),
       @_ASSUNTO nvarchar(50),
       @_DATA nvarchar(30) )
    AS
    BEGIN
       INSERT INTO EmailsRecebidos (De, Assunto, Data)
       VALUES (@_DE, @_ASSUNTO, @_DATA)
       WHERE NOT EXISTS ( SELECT * FROM EmailsRecebidos 
    				   WHERE De = @_DE
    				   AND Assunto = @_ASSUNTO
    				   AND Data = @_DATA);
    END

And the error is: 

&gt; Msg 156, Level 15, State 1, Procedure EmailsRecebidosInsert, Line 11  
Incorrect syntax near the keyword &#39;WHERE&#39;.



SQL Server Insert if not exists

What is the difference between `#temptable` and `##TempTable` in SQL Server?

Difference between #temptable and ##TempTable?

I have created a Scalar Functions, it was created successfully, but when I call the function using select statement, it says  Invalid object name &#39;dbo.fun_functional_score&#39;.

my function:

     ALTER function [dbo].[fun_functional_score] (@phy_id varchar(20))
     returns  varchar(50)

    as
    begin 

	declare @level_initial int, @level_current int
		
	-- initial functional score
	set @level_initial=(SELECT pflag.fun_level
	FROM tbl_phy_demographic_details as [phy] 
		inner join tbl_all_purple_flag_level as [pflag] on phy.Demographic_id=pflag.Id 
	WHERE phy.Physicion_id=@phy_id
		and pflag.visited_count=(select MAX(visited_count)-1 from tbl_all_purple_flag_level ))

	
	-- current functional score
	set @level_current=(SELECT pflag.fun_level
	FROM tbl_phy_demographic_details as [phy] 
		inner join tbl_all_purple_flag_level as [pflag] on phy.Demographic_id=pflag.Id 
	WHERE phy.Physicion_id=@phy_id
		and pflag.visited_count=(select MAX(visited_count) from tbl_all_purple_flag_level ))
	
	
	--to calculate functional score
	declare @fun_level varchar(20),@result varchar(50)
	
	set  @fun_level=@level_current-@level_initial;
	
	 if @fun_level = 0 	 set @result=&#39;Maintained&#39; 
	if @fun_level = &#39;-1&#39;  set @result=&#39;Minor Improvement&#39; 
	if @fun_level = &#39;-2&#39;  set @result=&#39;Moderate Improvement&#39; 
	if @fun_level = &#39;-3&#39;  set @result=&#39;Significant Improvement&#39; 
	if @fun_level =  &#39;-4&#39;  set @result=&#39;Substantial Improvement&#39; 
	if @fun_level =  &#39;1&#39;  set @result=&#39;Minor Reduction&#39; 
	if @fun_level =  &#39;2&#39;  set @result=&#39;Moderate Reduction&#39; 
	if @fun_level =  &#39;3&#39;  set @result=&#39;Significant Reduction&#39; 
	if @fun_level =  &#39;4&#39;  set @result=&#39;Substantial Reduction&#39; 
	
	
	
	
    return @result

    end


i used this select to call 


     select * from dbo.fun_functional_score(&#39;01091400003&#39;) as [er]

or 
     
     select * from dbo.fun_functional_score(&#39;01091400003&#39;) 

both showing error &quot;Invalid object name &#39;dbo.fun_functional_score&#39;.
&quot;

where i made error . can anyone help me...

how to call scalar function in sql server 2008

My SQL code is fairly simple. I&#39;m trying to select some data from a database like this:

    SELECT * FROM DBTable
    WHERE id IN (1,2,5,7,10)

I want to know how to declare the list before the select (in a variable, list, array, or something) and inside the select only use the variable name, something like this: 

    VAR myList = &quot;(1,2,5,7,10)&quot;
    SELECT * FROM DBTable
    WHERE id IN myList



SQL Server procedure declare a list

Does anybody know what is the limit for the number of values one can have in a list of expressions (to test for a match) for the IN clause?

&quot;IN&quot; clause limitation in Sql Server

I can&#39;t start the `SQL Server browser` from `SQL Service Configuration Manager 2008` version. There are absolutely no options to start the service. It&#39;s disabled as image shown below. How should I start the service again?

![window][1]


  [1]: http://i.stack.imgur.com/8FNXN.png

I cannot start SQL Server browser

I have two numbers as input from the user, like for example  `1000` and `1050`.

How do I generate the numbers between these two numbers, using a sql query, in seperate rows? I want this:

     1000
     1001
     1002
     1003
     .
     .
     1050


How to generate a range of numbers between two numbers?

I have some data that I would like to split based on a delimiter that may or may not exist.  

Example data:

    John/Smith
    Jane/Doe
    Steve
    Bob/Johnson

I am using the following code to split this data into First and Last names:

    SELECT SUBSTRING(myColumn, 1, CHARINDEX(&#39;/&#39;, myColumn)-1) AS FirstName,
           SUBSTRING(myColumn, CHARINDEX(&#39;/&#39;, myColumn) + 1, 1000) AS LastName
    FROM   MyTable

The results I would like:

    FirstName---LastName
    John--------Smith
    Jane--------Doe
    Steve-------NULL
    Bob---------Johnson

This code works just fine as long as all the rows have the anticipated delimiter, but errors out when a row does not:

    &quot;Invalid length parameter passed to the LEFT or SUBSTRING function.&quot;

How can I re-write this to work properly?

T-SQL split string based on delimiter

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have a primary key and identity defined. 

But since I have to delete some records from the table, the identity seed for those tables will be disturbed and the index column (which is auto-generated with an increment of 1) will get disturbed.

**How can I reset the identity column after I deleted the records so that the column has sequence in ascending numerical order?**

The identity column is not used as a foreign key anywhere in database.

Reset identity seed after deleting records in SQL Server

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that server.

The problem happens when trying to design the package.  I have added an excel connection and pointed it at the Excel file on a local disk (the same file I have already successfully imported using the import wizard). When I add an Excel Source to the DataFlow and specify the excel connection, when I go to the Name Of the Excel Sheet Drop down I just see &quot;No tables or views can be loaded&quot; and get the following error.

&quot;Could not retrieve the table information for the connection manager.
Failed to connect to the source using the connection manager ...&quot;

I can&#39;t find this error logged anywhere and i don&#39;t know why it is failing. The directory is shared to Authenticated users and the file is not in use.

Any ideas how to debug this error? I understand there can be issues running this in 64 bit mode, but does that apply to development?

I should add that it is an excel 2007 file .XLSX and the connection is set to Excel 2007.

2019-11-08 The answer by GavB841 below looks promising, if anyone tries it and it works please let me know. (I am no longer working in this area.)

SSIS Excel Connection Manager failed to Connect to the Source

I have a SQL Server job that runs monthly that runs in server. Job is using an SSIS package and is supposed to extract the data from database and and create an Excel sheet and copy the data into Excel 2003.

I actually got around 140,000 rows from the database due to truncation issue in Excel 2003 (Excel supports 64,000 rows). So I modified the config file to support 2007 Excel format.

    &quot;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=&quot;  +  @[User::FullPath]  + &quot;;Extended Properties=\&quot;Excel 12.0;HDR=YES\&quot;

But when I try to execute the job, it fails showing error message:

&gt; &quot;The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered&quot;

Microsoft.ACE.OLEDB.12.0 is not registered

I&#39;m trying to import a flat file into an oledb target sql server database.

here&#39;s the field that&#39;s giving me trouble:

![enter image description here][1]

here are the properties of that flat file connection, specifically the field:

![enter image description here][2]

here&#39;s the error message:

&gt; [Source - 18942979103_txt [424]] Error: Data conversion failed. The
&gt; data conversion for column &quot;recipient-name&quot; returned status value 4
&gt; and status text &quot;Text was truncated or one or more characters had no
&gt; match in the target code page.&quot;.


What am I doing wrong?


  [1]: http://i.stack.imgur.com/CBYws.png
  [2]: http://i.stack.imgur.com/GTBcj.png

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The `Microsoft.ACE.OLEDB.16.0` provider is not registered on the local machine. (`System.Data`) 

It is not the same version I think some other patching is needed

&#39;Microsoft.ACE.OLEDB.16.0&#39; provider is not registered on the local machine. (System.Data)

I am creating a SSIS project via Biml (Using the current version of BimlExpress per the [Varigence BimlExpress page](https://www.varigence.com/BimlExpress)) that uses a script component within a Data Flow Task.  The project is created without issue however errors when it gets to the Script Component:

&gt;Could not load file or assembly &#39;Microsoft.SqlServer.DTSPipelineWrap, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91&#39; or one of its dependencies. The system cannot find the file specified.

&gt;at ScriptMain.PreExecute()
   at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()

I can see this dll within the GAC and when I try to add the reference manually, SSIS states that I can&#39;t add it as it is already included in the project.

However, if I open the Script Component and manually `Build` it - but change nothing else - the Data Flow Task will run through without issue.

To clarify, I know I have changed nothing else as I am recreating this project from the Biml each time I want to test a new approach, which provides a consistent baseline.

---

Does anyone know why a Script Component that includes a reference to a GAC dll, will only work when manually `Built` but not beforehand?

I have used this exact Biml before without issue, though on a different environment.  Worked using Visual Studio 2012 against a SQL Server 2016 instance yet doesn&#39;t here within Visual Studio 2015 (targeting 2012) against a SQL Server 2016 instance.

For further context I have also tested this outputting the SSIS Project targeted at SQL Server 2012, 2014 and 2016 with the exact same error message.

---

#Update

This appears to definitely be a dll version problem in the project as output from BimlExpress, in that if I manually create the `v4.0_14.100.0.0__89845dcd8080cc91` folder with the version 13 dll inside at `C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.DTSPipelineWrap` the script component now errors out with the following:

&gt;System.InvalidCastException: Unable to cast COM object of type &#39;System.__ComObject&#39; to interface type &#39;Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100&#39;. This operation failed because the QueryInterface call on the COM component for the interface with IID &#39;{*ID removed just in case*}&#39; failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

&gt;at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)

&gt;at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()

&gt; at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)

SSIS Script Component Cannot Load Assembly Until Manually Opened

I&#39;d like to convert result table to JSON array in MySQL using preferably only plain MySQL commands. For example with query

    SELECT name, phone FROM person;

    | name | phone |
    | Jack | 12345 |
    | John | 23455 |

the expected JSON output would be

    [
      {
        &quot;name&quot;: &quot;Jack&quot;,
        &quot;phone&quot;: 12345
      },
      {
        &quot;name&quot;: &quot;John&quot;,
        &quot;phone&quot;: 23455
      }
    ]

Is there way to do that in plain MySQL?

EDIT:

There are some answers how to do this with e.g. [MySQL and PHP][1], but I couldn&#39;t find pure MySQL solution.


  [1]: https://stackoverflow.com/questions/383631/json-encode-mysql-results

Content Type	Original Author	Original Content on Stackoverflow
Question	john Gu	View Question on Stackoverflow
Solution 1 - Sql Server	billinkc	View Answer on Stackoverflow
Solution 2 - Sql Server	Kishore	View Answer on Stackoverflow

Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

NoSuchMethodError in javax.persistence.Table.indexes()[Ljavax/persistence/Index

iOS autolayout to center my view between two views

Attributions