kpmandani (12/2/2016)

---

I want to send a csv file using SQL Server only when it has more than 1 record present in it. Daily this file is getting cleared and updated...

drew.allen (12/2/2016)

---

Phil Parkin (12/2/2016)

---

Just having a mind warp on how to insert into the address table and get that unique int value and put it into the correct master row...

This...

You need to return inv.Active to the outer query, if you need it there.

SELECT

StationName

, AiredDateTime

, AiredISCI

, OrderNumber

, Line

,...

This question is clearly puzzling us all. Can I suggest that you create a 'dumbed-down' version, exemplifying the issue in consumable code, which we can run for ourselves? I think...

On which table is the column 'Active'?

For readability, please use IFCode formatting in future. Here is that code again:

SELECT

StationName

, AiredDateTime

, AiredISCI

, OrderNumber

, Line

, ...

What versions of SQL Server are you migrating from/to?

r5d4 (11/25/2016)

---

I’m running SSMS 2016 on the server itself via RDP.

When I open a script from the solution explorer or script a table as a SELECT, the query window opens...

A DACPAC is not something which can be edited directly, AFAIK.

Instead, you need...

Please give us some sample data and also show how you would like that data to be formatted.

The sample data should be in the form of INSERTs to a temporary...

reelnoncents (11/23/2016)

---

I assumed that may be questioned 🙂

What I mean is different data sets. So for example, let's say I have 5 "file types"...

1) Product Mix file

2) Sales file

3) Items...

Please describe what you mean by "file type".

jasona.work (11/23/2016)

---

Phil Parkin (11/23/2016)

---

chuck.forbes (11/23/2016)

---

The Network Team is still thinking that Automatic Windows Update was accidentally enabled on this server. Jeff, are you saying that even if that was the...

John Rowan (11/23/2016)

---

Guessing that the DTS.Runtime library is referencing the local SSIS instance. Not sure how you'd point that to another catalog. You may check the class properties...