Viewing 15 posts - 8,476 through 8,490 (of 13,876 total)
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
April 20, 2015 at 8:51 am
ahammer 40362 (4/20/2015)
April 20, 2015 at 8:22 am
spaghettidba (4/20/2015)
No values will be in the column, since it's being added by the ALTER TABLE command. What do you mean exactly?
Oops. It's Monday morning and I've clearly not had...
April 20, 2015 at 3:12 am
spaghettidba (4/20/2015)
Use "WITH VALUES" in your default specification:
alter table test add column2 int default(0) WITH VALUES
Would this overwrite existing non-null values, as that appears to be the requirement?
April 20, 2015 at 2:15 am
ankithimmatlalshah (4/20/2015)
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...
April 20, 2015 at 1:46 am
vignesh.ms (4/20/2015)
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)...
April 20, 2015 at 1:19 am
kapil_kk (4/20/2015)
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...
April 20, 2015 at 12:16 am
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...
April 19, 2015 at 3:07 am
It may not be relevant here, but ...
Presumably you are aware of all of this[/url] stuff regarding the new cardinality estimator.
April 17, 2015 at 4:17 am
Can you answer Gail's question?
April 16, 2015 at 10:37 am
Is there any other way we can achieve this in optimal way.
Use SSIS and throw away your linked server 🙂
April 16, 2015 at 9:03 am
marc.heidemann (4/16/2015)
http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/04/16/sql-server-2014-service-pack-1-has-released.aspx
Thanks! And here is the link again, for lazy clickers:
April 16, 2015 at 4:03 am
marc.heidemann (4/16/2015)
April 16, 2015 at 3:23 am
Can you include the proper DDL, as generated in SSMS?
Also, you have not asked a question, leaving us to guess.
April 16, 2015 at 3:08 am
Viewing 15 posts - 8,476 through 8,490 (of 13,876 total)