ankithimmatlalshah (4/21/2015)

---

Hello Phil,

Thank you for the quick response.

For first point, I will re-confirm with customer that can we create the SQL script task that will first create the all tables...

There are a lot of questions here and several of them required detailed answers in their own right.

But for me, one thing really stands out. Best practice is not to...

pharmkittie (4/20/2015)

---

They have a forum I posted to but I don't think I can call until I buy the license. I was surprised to see that a search of...

OK, I'll ask the obvious question. Have you asked Cozyroc, given that it's their product?

-Edit, fixed typo.

The way I would do it is closely related to Steve's suggestion:

1) Get the database code scripted out using VS or Redgate SQL Compare.

2) Get it into a VCS.

3) Devise...

mxy (4/20/2015)

---

I am trying to replace object name in views , triggers, stored procs, UDF,TVF etc. created a automated script based on Search condition is 'xyz' replace with pqr in...

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 ...