The only resolution suggestions I've found are here:

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

HTH,

There are a couple of interesting articles on that theme...

http://www.sqlservercentral.com/articles/Administration/61319/ by Dawyl Quadros

and

http://www.sqlservercentral.com/articles/Career/61535/ By Andy Warren

...are two that I keep handy.

To get to the task properties you need to right-click in an empty space on the DTS designer page. On the context menu choose "Disconnected Edit". You can then...

You could also set an arbitrary destination to create the task and then perform a disconnected edit to change the DestinationObjectName of the transform data task manually.

When you go back...

Maybe could've changed anything to something!!! Anything at all will do!

:crazy:

I wouldn't say that makes you elitist in the slightest. If you...

Is it possible to be constructively elitist?:ermm:

I'm sorry to say this guys but this thread is sounding a little elitist.

I can certainly understand the frustration caused by a distinct lack of detail provided (or not) by...

I think that it's all about $$$.

The increased complexity of having to sustain a connection between two countries can only be a burden. Imagine if one of the US servers...

Hi,

Check out the attachment, it's a SP that I've built to get all the sheets' names from an Excel workbook.

HTH,

Hi,

I would have thought that forensics in a database sense would be investigating data breaches and the like. Having a quick scout about, WikiPedia provided this:

http://en.wikipedia.org/wiki/Database_Forensics

HTH

Hi,

Well done for solving it, but could you post your solution too please. It'll provide a reference for anyone else with the same query.

Thanks, 😀

Hi,

You could build your command string containing parameters for the batch file in a variable (safely assuming it's under 8000 characters) and then execute it using xp_cmdshell.

This code, if saved...

Hi,

There is an option you can perform when using DTS run through xp_cmdshell in Management Studio (or Query Demonizer) that will output the encrypted command string for you. You can...

Hi Brandie,

I'm back from my hols and being back at work makes it feel like I was never away!

Just thought I'd let you know that I'd be looking at your...