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

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