mitzyturbo (11/1/2016)

---

Thanks guys for the replies

John - I got it working using the method you outlined, I used LEAD instead of LAG

Massive improvement on the performance too

Now I just...

kyagi.jo (11/1/2016)

---

Yeah, spent like 2.5 days, and was running out of options before today; was worried we'd purchased a SQL server enterprise license and would be crippled by being unable...

kyagi.jo (11/1/2016)

---

I was using SSDT 2015 and building the solution, producing an ispac file, dropping it on the server, and running (double clicking) the ispac file, to deploy the project...

kyagi.jo (11/1/2016)

---

Second breakthrough - I can deploy the package with no issues through the SSDT UI, it is only the ispac file that is not deploying properly! Very odd, I...

Outstanding! [sarcasm]

OK, could it somehow be a permissions thing?

How are you executing the...

subrahmanyam113 (11/1/2016)

---

Hi I am using a script to get details about database name, schema name, table name, row count and size of each table in GB. I would like to...

kyagi.jo (11/1/2016)

---

Thanks, there are still avenues to explore...

The reinstall of SSIS did not help.

I tried to make the script task in VB, no luck.

I tried the package deployment...

SteveD SQL (11/1/2016)

---

Hi,

SSIS 2008 R2 packages

The scenario is I am importing data from a file into a table which has a foreign key field which is optional. The foreign key...

kyagi.jo (11/1/2016)

---

I got the server updated, but still no luck.

It is now: Microsoft SQL Server 2016 (RTM-CU2) (KB3182270) - 13.0.2164.0 (X64) Build 9600

Looking at the previous versioning, this...

DamianC (11/1/2016)

---

Finally working

Thom A, misunderstood your example part

Set the expression of the variable to

"SELECT COUNT(*) AS recordCountDestination FROM " + @[User::tableName] + ";"

Also set the property EvaluateAsExpression to True

Remove any...

Deleted.

Or pass the table name to a stored proc, which returns the count as an OUTPUT parameter.

Suth (10/31/2016)

---

Hi,

I'm trying to send returned results of a query only if something is returned back in the query through the sp_send_dbmail function..

I've...

John Mitchell-245523 (10/31/2016)

---

If you have xp_cmdshell enabled, it may be simpler to run a dir command and put the results into a staging table. You can then count the...

mbrady5 (10/31/2016)

---

Good morning,

I'm looking for a good method to check if 4-.txt files exist in a folder. If they do not, I will send an email using the mail task.

Anyhow,...