I was suffering from the same issue. My problem was resolved by uninstalling management tools, restarting the machine then re-installing the tools.

Win 2012 R2 64bit: SQL 2014...

Nice to see the natural side of Steve!

Have a Merry Christmas Everyone!

Did you use the fixed width file type? Do you actually have more output, it just looks like one row?

This is a common problem with using the...

For clarity, are you running a t-sql script outside of the dataflow, and a second copy within the dataflow? Do both produce the same resultset? You said that you are...

Nice sample Matt.

Are you using sql2k5? If so take a look at BOL at a recursive CTE's (Common table expressions).

How long after the message do you run the DBCC SQLPERF and with which option(s)? Also how is your tempdb setup? What is the growth factor, and the...

Have you researched the system databases?

I assume you are talking about a SQL logon?

If you are questioning the relationship of the logon in the sysusers entry in the database to a SQL logon...

Check out this article

http://www.sqlservercentral.com/articles/Performance+Tuning/2863/

see if this may help any.

For simplicity sake, is this the output your looking for?

CREATE TABLE #tb1

(

id varchar(10),

date datetime

)

----

INSERT INTO #tb1

SELECT 101,'01/01/2000'

UNION

SELECT 102,'01/01/2001'

union

SELECT 103,'01/01/2002'

union

SELECT 104,'01/01/2003'

----

CREATE TABLE #tb2

(

id1 varchar(10),

id_Plan varchar(10)

)

----

INSERT INTO #tb2

SELECT 101,'A'

UNION

SELECT 101,'B'

union

SELECT 102,'A'

union

SELECT 102,'B'

union

SELECT...

And just how do you plan on passing the data to insert or update?

Allot would depend on your security standards, data volume, input sources, reporting or other usage of the database(s).

Do you want more of a data warehouse, or data marts.

Do you have...

From the output your query is producing try this simple change.

select

h.name as 'DataBase Name'

,t.name as 'Table Name'

,c.name as 'Column Name'

from sys.tables t

inner join sys.schemas h

on h.schema_id = t.schema_id

inner join...

Everyone who has posted should be able to receive the points for the day. 

Since two answers are correct, how do we accumulate...