Rather than the FMTONLY way, you could try this method instead. Maybe it will help:

http://stackoverflow.com/questions/1579476/using-temp-tables-in-ssis

ahammer 40362 (4/20/2015)

---

I am receiving a similar error in an SSIS package that I am writing. The package connects to my MS SQL Server 2005 SP 4 database and executes...

Oops. It's Monday morning and I've clearly not had...

Would this overwrite existing non-null values, as that appears to be the requirement?

ankithimmatlalshah (4/20/2015)

---

Hello Chris and Jeff,

Thank you for the response.

The data type for each column of all 50 files will always be varchar (255).

The requirement is like the client would like...

vignesh.ms (4/20/2015)

---

Hi There,

I want to set a default value to a column while adding it.

Create table test(id int )

insert into Test values(123)

alter table test add column2 int default(0)...

kapil_kk (4/20/2015)

---

Hi all,

I am getting error when I passed multiplt rows in less than condition:

create table #t1

( ID int)

INSERT INTO #t1

SELECT 1 UNION ALL SELECT 5 UNION ALL SELECT...

There is going to be no decent way of auto-creating the tables. A major reason for this is that columns in CSV files have no data types. Unless you interrogate...

Might as well use a data flow ...

It may not be relevant here, but ...

Presumably you are aware of all of this[/url] stuff regarding the new cardinality estimator.

Can you answer Gail's question?

Use SSIS and throw away your linked server 🙂

Thanks! And here is the link again, for lazy clickers:

http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/04/16/sql-server-2014-service-pack-1-has-released.aspx

marc.heidemann (4/16/2015)

---

Notice: The SQL SSIS team has found an issue with SP1 installation if SSIS catalog is present in the SQL Server instance.They are currently investigating this issue including possible...

Can you include the proper DDL, as generated in SSMS?

Also, you have not asked a question, leaving us to guess.