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

Thank you for the detailed response, whenriksen.

You are right in thinking that this is for a work-queue table ... in this case, for queues of SSIS packages waiting to be...

arkiboys (10/28/2016)

---

Phil Parkin (10/28/2016)

---

arkiboys (10/28/2016)

---

Thom A (10/26/2016)

---

Instead of using variables in the child package, use parameters. You can then pass the variables within the parent package as parameters to the...

arkiboys (10/28/2016)

---

Hello,

What topic does...

I just tested using 2013 ACE drivers and, even there, there is a 256-column...