first things that come to mind (without seeing any example code to go on) is using SUBSTRING and/or FOR XML

read up on them both, unless someone is kind enough to...

1....

Cadavre (2/7/2012)

Loundy (2/7/2012)

Recursive CTE's are pro:

http://msdn.microsoft.com/en-us/library/ms186243.aspx%5B/quote%5D

Hmmm. . . it is after all still a loop.

However, I'm not sure why you'd want to convert a recursive CTE into a...

why?

Recursive CTE's are pro:

http://msdn.microsoft.com/en-us/library/ms186243.aspx

Possible explanation

Quote:

By default, a 64-bit computer that has both the 64-bit and 32-bit versions of an Integration Services command prompt utility installed will run the 32-bit version at the...

interesting - as far as i'm aware the files haven't been moved....

i'll have to do some more digging then

We've managed to fix the problem.

The registry key pointing to the msdtssrvr.ini.xml file was pointing to D:\Program Files\Microsoft SQL Server\100\Binn

it should have been D:\Program Files(x86)\Microsoft SQL Server\100\Binn

🙂

Our dba's have told me that the account is fine.

Their suggestions were:

Restart the server

Install Sp1

Restart of the server (its a pre production server so no biggie) didn't fix...

i would "assume" so, were using network services for the SQL Server Browser and FT Daemon Launcher and there working ok. Unfortunately I don't have access to system permissions...

it really does have a v at the end 🙁

hi John,

I can connect to the db engine fine through ssms.

Were using 64 bit standard edition:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr...

Here is the ini.xml file.

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

<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>

<TopLevelFolders>

<Folder xsi:type="SqlServerFolder">

<Name>MSDB</Name>

<ServerName>UKSTG66PCSDB01v</ServerName>

...

Hi John,

Thanks for the response.

I can connect to the integration service through SSMS just can't expand the folder. I'm using the name of the server to connect (also...

Hi John,

I'm using SSMS to connect at this time not BIDS and yes i'm trying to connect from the same server.

this will delete anything older than 90 days based on CreatedDate

DELETE FROM dbo.logins

WHERE CreateDate < CONVERT(CHAR(10),DATEADD(DD,-90,GETDATE()),121);

i.e, anything older than 2011-11-04 (assuming its run today)