any other possible solutions?

Hi Everyone,

I was able to write the CTE for the decline reasons I mentioned above, if you look below, another problem I ran into was for credit bureau. I want...

I also deployed the package to SQL server Integration services, and when I run the package from there it works also. when I schedule it, it gives me the following...

I am sorry but what would be the UNC path?

Does the package has to be on the same server?

So I was able to convert it into a flat file, now I need to know how do I schedule it to send an email with the flat file attached.

On the SSIS when I run the OLE DB source to excel destination field it gives me an error 'cannot convert between Unicode and non uni code string data types'

Do...

Earlier in the select statement I also tried to convert the date in varchar, but I know then I would not be able to use the date functions.

,CONVERT(VARCHAR(10), CAP.decision_date,...

This happens to be a view query that needs to be run every night, needs to be converted to an excel file and email the attachment to couple of people.

Does...

Yes and that would give results from 0/81/15 till today....No help

Thanks Again, but this one is giving me all the results from the last 25 days till today...

why do we need a between clause if I only need records from...

Thanks Errikur,

I only want results from past 21 days, I tried this also:

AppDetails.DateDetailDisposed = DATEADD(DAY,-21,getdate())

Still gives me a blank result set

Thanks Scott,

How do I fix this code:

AppDetails.DateDetailDisposed BETWEEN getdate() - 25 AND getdate() - 20

I only need getdate() -21, but that's giving me blank output

Thank you guyz,

In the last part, when I just want to see (.AppDetails.DateDetailDisposed), 21 days less instead of (20-25 days) the whole result messes up.

I am using:

AppDetails.DateDetailDisposed = getdate() -...

Microsoft SQL Server 2012 - 11.0.5343.0 (X64)