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

What do you mean by this?

SQL!$@w$0ME (4/1/2016)

---

I would like to check if the results for a select query is null. If there are no rows returned print "no rows" else send an email.

What is the...

larry.andrews (3/31/2016)

---

I've stumbled into an unexpected situation.

I'm observing significant performance differences depending on how a child Package is launched.

Scenario 1 : Single Master Package calling Specific Packages

Scenario 2 : ETL...

Is the file path local to the client, or the server?

With some difficulty. I tried a few ideas & failed. Looking forward to seeing someone else...

Exactly what I was wondering.