If you disable an application, what is the point of having it in the first place?

Have you created a publication?

scarlam (12/16/2015)

---

Can you shed some light on what these appropriate wildcards in filespec might be? I was able to setup to load all files in directory, or load files...

Would you be so good as to provide an expanded example of the XML source data which includes multiple custom field definitions? Makes it easier for people to test their...

Try this:

select DATEADD(mm,-4,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))

Can you post the function definition?

scarlam (12/16/2015)

---

Has anyone had a chance to create a package that loops through directory and load files with specific word in file name? For example, flat file source where...

As the OP requested an exact match, why are we suggesting using LIKE here?

dmboyce1 (12/16/2015)

---

Hi,

I am probably considered a beginner at SQL compared to most of you!

Here is code that I have that works:

set @PAT_Filter=N'AND PATIENT.PAT_ExternalId like (''%123456'')'

I now have a long...

barry.andreasen (12/16/2015)

---

Sorry,...

g.britton (12/16/2015)

---

Alvin Ramard (12/15/2015)

---

Phil Parkin (12/15/2015)

---

g.britton (12/15/2015)

---

Of course. however...

barry.andreasen (12/16/2015)

---

I am coming up to speed on SSIS packages for use in a product solution that I am involved with. We have defined a number of packages that...

I...

Nothing is wrong.

You are partitioning by row number, which is unique in the source data - making the partition redundant. If you sum a column which contains a NULL and...

Eshika (12/15/2015)

---

Thank you for your response,

I have a package and it is one of the 3 deployed packages in a folder. Do I need other two packages as well to...