Thanks for the suggestion. Is certainly a way to achieve the goal.

Went for a scripttask in the controlflow setting and setting the result to Dts.TaskResult = (int)ScriptResults.Failure; when variable was...

Eagerly awaiting the next edition.

In case you need to run an ssis dashboard report not from the management studio, you can use a replacement by mnowill[/url].

For readonly security...

You can click on the link TAF in the above post.

I don't have experience with it but know that you can specify multiple addresses under one TNS-alias. Sometimes an oracle...

was it Oracle TAF automatic fail over using tnsnames ?

case sensitive tablenames?

Thanks for the reminder on techorama[/url].

Thanks for the excellent stairway. Could you add level 15 and 16 to the general overview of stairway to ssis?

congratulations

Powershell example[/url]

Using sc from the resourcekit[/url]

Otherwise with psexec?

Your best bet is to redirect the install to the sxs\sources on the instalmedia.

Start with Oracle concepts. What is an instance, what are controlfiles, redologs, undotablespace, temptablespace, archivelogs.

You might consider Oracle Developer as free query tool

Basic troubleshooting tool for administration: sqlplus, couldn't...

Does there exist some form of datatiering within a database in ms sql server? Like moving popular data to faster disk (automagically?)

Thanks, that is from the management studio. Is there a commandline equivalent?

Maybe you can ask the oracle engine to convert it to xml first (instead of clob). Possible example[/url]

Not sure if it is fixed yet but discusses about casting it as xml-type in openquery