Alvin Ramard (12/17/2015)

---

Phil Parkin (12/17/2015)

---

loki70 (12/17/2015)

---

Grasshopper - That worked perfectly! I never stumbled on this "preview" version in my searches, but your link worked great.

Thank you very much for...

You could...

By the way, SSIS is quite happy to handle direct connections to servers (ie, there may be no need to use a linked server within SSIS itself).

Create a string parameter in your package and set it to the query string.

Change your dataflow source to use what's in the parameter, not the hard-coded query.

Use different configurations to...

OK, then I am not sure I can help.

As Excel holds dates as integers (try formatting your date as 'General' and you will see what I mean), I would have...

murtzd (12/17/2015)

---

Hi all,

I'm experiencing a very frustrating issue. I am using the guide below to read a cell value in Excel into a SSIS variable;

http://www.techbrothersit.com/2013/11/ssis-read-excel-cell-value-in-ssis.html

It works very well for anything...

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