No we don't have VARCHAR(MAX) in our DB. Even I know that's not the issue but this is something which I want to know why this problem is solved because...

Does anyone know why CTE's wont work in SSIS 2005?

Because for me the SP which is running inside the package has created the problem above.

There are like 6 CTE's inside...

Well Typically One of the Developers team wrote the code. I don't have permission to change the code. The error which I showed occurs only when I use MessageBrokerDB. Other...

Here is the RSReportServer.Config file..

<Configuration>

<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAAR49Wq3/ykOPdse5Zih3hgQAAAAiAAAAUgBlAHAAbwBy

AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAADAAAAAEAAAAF5trN8bXISfrROSi6E+NEoAAAAA

BIAAAKAAAAAQAAAAPHEzVpxXXSbycWviyRDN+QABAAADgEDOm4xpSaRQCgBHJQeqvuov14kQgw1L

qQVKPJbknL1DO/PM+B9nPxH2AnOGD+EVLV3avZhcJtyUeM/htBdxlSefrwU3lC5LiC+uGxRxCRz6

1wGTV8I2iMwL+4KAejFp0kVbXX71vTcxMCeerB8CrP1elftmtbdgSkFX4Hk2Jdl01ByeiFWHvBpN

fQEgvLvJmtpLRtacchChSPVOPSxxNmmL9D3t27loDykPXhH3J5xe3cIU1BY2M5gDDAJJlgnZpy6F

D88w4ABlQR0p8y17hlgKleX3o4Q+z1nSociS61qlgSX3wWolqWt8BHJ/DJY+hxxStgdrLlC5SVmf

u3XYFAAAADkcGHdZJs7DVR6+GSKQAhsAgYK6

</Dsn>

<ConnectionType>Default</ConnectionType>

<LogonUser></LogonUser>

<LogonDomain></LogonDomain>

<LogonCred></LogonCred>

<InstanceId>MSRS11.MS2012</InstanceId>

<InstallationID>{1e54db69-9134-4993-9ff5-837bab8c8be8}</InstallationID>

<Add Key="SecureConnectionLevel" Value="0"/>

<Add Key="DisableSecureFormsAuthenticationCookie" Value="false"/>

<Add Key="CleanupCycleMinutes" Value="10"/>

<Add Key="MaxActiveReqForOneUser" Value="20"/>

<Add Key="DatabaseQueryTimeout" Value="120"/>

<Add Key="RunningRequestsScavengerCycle" Value="60"/>

<Add Key="RunningRequestsDbCycle" Value="60"/>

<Add Key="RunningRequestsAge" Value="30"/>

<Add Key="MaxScheduleWait" Value="5"/>

<Add Key="DisplayErrorLink" Value="true"/>

<Add Key="WebServiceUseFileShareStorage" Value="false"/>

<!-- <Add Key="ProcessTimeout"...

I am getting the same error for both ReportMangerURL and WebServiceURL.

Below is what Web.Config content is

<?xml version="1.0" encoding="utf-8"?>

<configuration>

<configSections>

<section name="MicrosoftWebControls" type="System.Configuration.NameValueSectionHandler, System, Version=2.0.3600.0, Culture=neutral,...

I couldn't find the config file. But No I don't have any idea that the Oracle Database is added to the connections.

Yes. It worked perfectly. I found the CharIndex(...) but I need some more practice to use it the way you have given. I got these questions from my friend. I...

Hi,

Sorry I forgot to Paste What I worked on so far.

Well the general picture I got it with this code

DECLARE @Year VARCHAR(4)

DECLARE @FullDate DATETIME

DECLARE @ReturnDay VARCHAR(10)

SET @Year = '2012'

SET...