Further to Gail's comment, your options are to either change your TRUNCATEs to DELETEs, or DROP CONSTRAINT / TRUNCATE / CREATE CONSTRAINT.

doasidont (4/5/2016)

---

I created a table using a query, but the table needs an ID column as primary key. First question is: Is there a make table query command that...

In addition, the query would be easier to read if suitable table aliases were used.

Tables should be schema-qualified throughout.

Please attach an actual execution plan and DDL for all the tables.

Also tell us what you have tried so far and your ideas about what the underlying problems may be.

OK, let me try again with this post.

I have some questions about your sample code. Looking only up to the end of the first APPLY:

select top 10

...

So am I right in thinking that the number of columns which you are returning depends on the number of rows in the temp table? There's some unusual stuff going...

Tava (4/4/2016)

---

Phil,

I've had a quick read, I'm a little confused... The values of 4,8,30,N... will be passed via the #temp table i created.

Since I'm using an outer apply in this...

Have a look here[/url].

Dynamic SQL is a good option in this case.

I recommend the following:

a) Use the project deployment model, to take advantage of the benefits...

'Tiddled' is what I was last Friday night....

swansonm (4/4/2016)

---

[font="Courier New"]Suppose I have the data set below:

contract lineitem effectiveDate termDate rate

1234 1ITEM110/12/20054/4/2016...

OK. I was wondering whether the VS debug overhead might have been a factor, but it...

Which version of SSIS are you using?

If 2012 or later, there is no need to use a config file for this.

sqlbaby2 (4/2/2016)

---

In SSIS, how to write condition to split string value to different destination ? Example if type='Item' then go db a else db b. Thanks

**Please delete the post as...

Or run an UPDATE query...