The screenshot was from BIDS.

CEWII

Ihink it is effective declared when it is entered in as a report paramter, so just use @Date if that is how you declared it in the report parameters. ...

Is yuor intention to run it locally or on the server? If locally you can probably add a reference to Microsoft.SQLServer.ManagedDTS and instantiate the package and run it locally....

I'm sorry to be a little obtuse, but I was unaware you could use things like system.io in expressions?

Also, I need to ask WHY you would do this in a...

I wasn't solving your problem directly, I was showing you how I had actually used it in one of my reports where I have a start date and end date...

TSQL wise I think that xp_cmdshell is really the best way.

However, I have done this in SQLCLR, the assembly had the permission set of EXTERNAL_ACCESS if I remember. I'm...

You shouldn't need to declare it, just use it..

SELECT DBName, Size=SUM(Size), ColDate=CONVERT(varchar(10),ColDate,101)

FROM dbo.Tracking

WHERE ColDate BETWEEN @StartDate AND @EndDate

GROUP BY DBName, ColDate

ORDER BY DBName, ColDate

@StartDate and @EndDate are...

Matt Miller (8/17/2009)

..per machine/IP address. It's probably a given, but it is sometimes useful to add the...

Well unfortunately that didn't help at all.. Have you had the DTC monitor open when a transaction was attempted, do you see the numbers go up for an attempted...

Paul,

Perhaps I'm being too semantic, I see default as if you install the product and do nothing else you can always count on the port being 1433 for a default...

The SQL Errorlog usually references DTC, what does it have to say about DTC in the SQL start that had problems?

CEWII

Only pull over what has changed as opposed to a full copy each time. If you can tell that a record has changed easily then all you do is...

Have you reviewed the configuration of DTC itself. And since you mention clustering, were they all running on the same server before and now they are seperated. When...

Are you re-pulling the data every time? If so is there any way to perform more of a delta operation, this would significantly reduce I/O and latency and increase...

That is shockingly bad performance. The other thought I had is what ELSE is going on on the source and destination servers at the same time, could there be...