If the table structure matches you can use UNION which will remove duplicates also .

select * from table1

UNION

select * from table2

Just to start with and to make sure your login actually works with your SQL . Try to connect to your server

LOCAL-IP.\SQLEXPRESS with SQL login as local-sql-user and password=p@ssw0rd

Now...

This is the version of SQL I have installed

Microsoft SQL Server 2014 - 12.0.4100.1 (X64)

Apr 20 2015 17:29:27

Copyright (c)...

This issue has been fixed . It was related to version of SQL server connectivity tools installed in the box .

1. I tried changing the version manually in XML...

Tried the steps , its still failing with same error . I have tried with one package out of five package . Driving me nuts . I can open the...

Check this http://www.sqlrepair.org/ you may able to repair . But I doubt if you can . I have not tried myself , but you can give...

The first thing to looks for is execution plan , which tells alot about how optimizer is processing this . I would say please paste the Exec plan...

I have figured the solution for this issue .

It was related to how table creation script was formatted . It is working fine now via SSIS

Correct Way

CREATE...

Database ID and Name is always same in exception . What I am missing here for SSIS to run fine ..

---------------------------------------------------------------------------------------------------- ERROR :: 615 :: Could not find...

Jeff ,

I changed number to nvarchar to match data type of name column from sys.databases . It is still failing when I call from SSIS . :crazy:

SP2 is...

This is SP1.

CREATE PROCEDURE [dbo].[SP1]

AS

/*Create Table variable to hold the data that needs to be processed*/

DECLARE @databases TABLE (

id...

Yes , you can do that . You just need to initialize one subscription which won't impact other existing subscription

Something similar and close to question was discussed in past .

http://www.sqlservercentral.com/Forums/Topic1316138-146-1.aspx

It looks like you are trying to create subscription using your "Create publication custom script" and running it on Subscription database where it is failing which it will .

Probably something like this .

select top 100 a.name, b.name,sc.DATA_TYPE from sys.views a inner join sys.columns b

on a.object_id = b.object_id

INNER JOIN INFORMATION_SCHEMA.COLUMNS SC ON b.name = sc.COLumn_name

where a.name like '%Case_Times%'