Sergiy, thank you for taking the time to write these informative posts.

I admit that I am guilty of following Paul White's recommendations as would a sheep and now I shall...

zouzou (6/28/2016)

---

I found out when i refer to an instance name inside the SSIS package it doesnt work when you deploy the package in sql job although in Studio is...

Eric M Russell (6/28/2016)

---

Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source database server....

Have you verified that the SQL Agent service account has requisite permissions on the target SQL Server instance?

Jeff Moden (6/27/2016)

---

jeffe_verde (6/26/2016)

---

The files have data for the Asia-Pacific, EU, and the Americas financial markets (thus the AP, EU, and AM in the file names), and each file is...

zouzou (6/28/2016)

---

Hello there

I have an issue with my SSIS packages they run fine on Studio 2013 but when you try to run them as a SQL job in SQL...

jeffe_verde (6/25/2016)

---

I receive three versions of a file each day, which I then import. But the file names are such that my ForEach loop processes the files out of...

Paul White suggests that the NOT EXISTS ... INTERSECT form produces better query plans than the EXCEPT form, and that's why I use it. See here (in the comments).

UPDATE is probably better than MERGE.

If you are a fan of MERGE, please take a read of this[/url] and decide whether, perhaps, you should reconsider.

And rather than using this type...

Ed Wagner (6/23/2016)

---

Phil Parkin (6/23/2016)

---

Jeff Moden (6/23/2016)

---

On the "Brexit" thing, the folks in GB really need to consider the ramifications to their automotive industries. The EU has a 10%...

Jeff Moden (6/23/2016)

---

On the "Brexit" thing, the folks in GB really need to consider the ramifications to their automotive industries. The EU has a 10% import tax and GB...

itortu (6/23/2016)

---

I would like to ask for help reviewing the conversion I just did taking a piece of vb6 code and turn it to sql syntax.

VB6

[code-"sql"]

IIF([Type]...

Great, well done!

I wonder if that anti-aging serum works on old farts like me....

rocky_498 (6/22/2016)

---

Hi Guys,

I need help.

Here is my sample data

ID,FNAME,STATE,AGE

1,JIM,CA,12

2,CARLOS,NY,14

3,JENA,CA,15

4,TIM,GA,12

What I want, I want to create an SSIS Package, where I can create a .csv file from the above data....